Odp: Huge view file - Mailing list pgsql-bugs

From Łukasz Skowroński
Subject Odp: Huge view file
Date
Msg-id 00df01c1377a$653e3d00$b84cfea9@g6c5w3
Whole thread Raw
In response to Huge view file  (Łukasz Skowroński <lskowron@elka.pw.edu.pl>)
Responses Re: Odp: Huge view file
List pgsql-bugs
From: Tom Lane <tgl@sss.pgh.pa.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



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Huge view file
Next
From: Tom Lane
Date:
Subject: Re: Odp: Huge view file