Re: Question about performance of planner

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bhirt(at)mobygames(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org, bhirt(at)berkhirt(dot)com
Subject: Re: Question about performance of planner
Date: 2000-11-22 19:08:53
Message-ID: 12230.974920133@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Brian Hirt <bhirt(at)mobygames(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2000-11-22 19:27:50 Re: Questions on RI spec (poss. bugs)
Previous Message Martin A. Marques 2000-11-22 19:07:44 Re: Crash during WAL recovery?