Re: 8.2.4 serious slowdown

From: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
To: "Sim Zacks" <sim(at)compulab(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 8.2.4 serious slowdown
Date: 2008-01-10 15:50:42
Message-ID: a595de7a0801100750ja8e1254k132884bc4738998f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

2008/1/10, Sim Zacks <sim(at)compulab(dot)co(dot)il>:
> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2008-01-10 15:53:34 Re: Time stamp issue
Previous Message Scott Marlowe 2008-01-10 15:49:58 Re: Time stamp issue

Browse pgsql-hackers by date

  From Date Subject
Next Message Isak Hansen 2008-01-10 15:54:15 Re: 8.2.4 serious slowdown
Previous Message Gregory Stark 2008-01-10 15:45:30 Re: flex/bison output wrongly created in the source directory