Re: Question about performance of planner - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Question about performance of planner
Date
Msg-id 12230.974920133@sss.pgh.pa.us
Whole thread Raw
In response to Question about performance of planner  (Brian Hirt <bhirt@mobygames.com>)
List pgsql-hackers
Brian Hirt <bhirt@mobygames.com> writes:
> I have a question about the performance of the planner in 7.1.  I've been
> testing the 11/21 snapshot of the database just to get an idea of how it
> will work for me when I upgrade from 7.02   I've noticed that some queries 
> are taking much longer and I've narrowed it down (i think) to the planner.

Does EXPLAIN show the same query plan in both cases?

> If anyone is interested in this, I'll be happy to supply you with information
> that would help track this down.

Sure.  Let's see the query and the database schema ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: regressplans failures
Next
From: "Martin A. Marques"
Date:
Subject: Re: Crash during WAL recovery?