Huge view file
Hello,
I created a view named some_view. Postgresql behaves quite strange
because it creates some_view file which has almost 600 MB. I'd like to ask
you:
- under what circumstances PGSQL writes anything to a view file?
- what it writes?
- why this file is so huge? Could this be a bug?
Best Regards,
Luke
=?iso-8859-2?B?o3VrYXN6IFNrb3dyb/Fza2k=?= <lskowron@elka.pw.edu.pl> writes:
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.
regards, tom lane
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
=?iso-8859-2?B?o3VrYXN6IFNrb3dyb/Fza2k=?= <lskowron@elka.pw.edu.pl> writes:
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?
Perhaps your app does inserts into the view and you don't have a rule to
redirect the inserts elsewhere? 7.1 will complain about that, but 7.0
just silently does the insert...
regards, tom lane