Re: [PERFORM] Huge difference in query performance between 8.3 and 8.4 (possibly)

2009-07-09 Thread Hartman, Matthew
> From: pgsql-performance-ow...@postgresql.org [mailto:pgsql-performance- > ow...@postgresql.org] On Behalf Of Robin Houston > Sent: Thursday, July 09, 2009 12:35 PM > We have a query that runs very slowly on our 8.3 database. (I can't > tell you exactly how slowly, because it has never successful

Re: [PERFORM] Huge difference in query performance between 8.3 and 8.4 (possibly)

2009-07-09 Thread Tom Lane
Robin Houston writes: > We have a query that runs very slowly on our 8.3 database. (I can't > tell you exactly how slowly, because it has never successfully run to > completion even when we left it running overnight.) On the 8.4 > database on my laptop, it runs in about 90 seconds. Of course there

Re: [PERFORM] Huge difference in query performance between 8.3 and 8.4 (possibly)

2009-07-09 Thread Alvaro Herrera
Robin Houston escribió: > We have a query that runs very slowly on our 8.3 database. (I can't > tell you exactly how slowly, because it has never successfully run to > completion even when we left it running overnight.) On the 8.4 > database on my laptop, it runs in about 90 seconds. Of course the

[PERFORM] Huge difference in query performance between 8.3 and 8.4 (possibly)

2009-07-09 Thread Robin Houston
[ Attempting to resend, because it didn't seem to get through last time. ] We have a query that runs very slowly on our 8.3 database. (I can't tell you exactly how slowly, because it has never successfully run to completion even when we left it running overnight.) On the 8.4 database on my laptop,