Odp: Huge view file

From: Łukasz Skowroński <lskowron(at)elka(dot)pw(dot)edu(dot)pl>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Odp: Huge view file
Date: 2001-09-07 08:52:14
Message-ID: 00df01c1377a$653e3d00$b84cfea9@g6c5w3
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> > I created a view named some_view. Postgresql behaves quite strange
> > because it creates some_view file which has almost 600 MB.
>
> Uh ... what PG version is this? In recent releases views don't even
> *have* any associated file.

Hi Tom!
It is PG 7.0.2-17. This problem doesn't concern me personally, I can't
even repeat it - everything works fine for me. I was just asked to solve it.
Well, we would like our application to be compatible with PG 7.0 so I need
to track this behaviour. Do you have a clue when PG could write anything to
a view file and where I can find it in source tree?

Best Regards,
Luke

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-09-07 13:49:47 Re: Odp: Huge view file
Previous Message Tom Lane 2001-09-07 04:49:21 Re: Huge view file