Re: Question about performance of planner

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Question about performance of planner
Дата
Msg-id 12230.974920133@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Question about performance of planner  (Brian Hirt <bhirt@mobygames.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: regressplans failures
Следующее
От: "Martin A. Marques"
Дата:
Сообщение: Re: Crash during WAL recovery?