> From: pgsql-performance-owner@xxxxxxxxxxxxxx > [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx] On Behalf Of Piñeiro > > TIP 6: explain analyze is your friend > Well, yes, it is a friend, but as the select at postgre Sarge version > never finished I can't use a explain analyze. I show you the explain, > with the hope that someone has any idea, but i think that > this is almost > indecipherable (if you want the Woody ones i can post the explain > analyze). Thanks in advance. Does the machine run out of disk space every time? Is it possible to try the query on a different machine with more hard drive room? An explain analyze of the slow plan will be much more helpful than an explain, even if its from a different machine. If its generating a large temp file, it is another sign that the query is doing some kind of large cross product.
