2008/1/10, Sim Zacks <sim@xxxxxxxxxxxxxx>: > I just upgraded my database server from 8.0.1 to 8.2.4 > Most things went very well, but I have a couple of queries that really slowed down with the new server. > On 8.0.1 the query took less then 3 seconds to complete. On 8.2.4 the same query > (I vacuumed the database before running the query) takes 60 seconds (10 minutes with Explain Analyze). > > The data is exactly the same on the 2 servers. > > To test for hardware differences, I loaded 8.0.11 onto a test server restored the database and ran the query. > It took about 3 seconds. I then uninstalled postgresql and installed version 8.2.4 and restored the database > and the query took about 60 seconds. > > On the 8.2.4 the CPU usage (as seen from top) goes up to about 97% for most of the 60 seconds of query. > On 8.0.1, it didn't. > > I have the explain from both databases, if someone could help me walk through this, I would much appreciate it. I have seen performance degradation at every new version since 7.3. But now 8.3 is a complete disaster. It could be that my most expensive query is just a corner case, but I don't believe it. I posted about it but the whole thread disappeared from the archives. It can still be found here: http://archives.free.net.ph/message/20080105.004509.22be255d.es.html Could you try 8.3 and see what happens? Keep the emails in case this thread mysteriously disappears. Regards, Clodoaldo Pinto Neto ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly