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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Robin Houston <robin(dot)houston(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Huge difference in query performance between 8.3 and 8.4 (possibly)
Date: 2009-07-09 17:02:31
Message-ID: 20090709170231.GF6414@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 there
> are several differences between the two instances, but I wonder
> whether query planning improvements in 8.4 could essentially account
> for it.

Of course. Great news. Congratulations.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2009-07-09 17:09:11 Re: Huge difference in query performance between 8.3 and 8.4 (possibly)
Previous Message Alexander Staubo 2009-07-09 16:39:15 Re: Sorting by an arbitrary criterion