Re: Poor Performance after Upgrade

Поиск
Список
Период
Сортировка
От Steinar H. Gunderson
Тема Re: Poor Performance after Upgrade
Дата
Msg-id 20070822042425.GA22037@uio.no
обсуждение исходный текст
Ответ на Poor Performance after Upgrade  (Ben Perrault <ben@mail.creepingfur.org>)
Список pgsql-performance
On Mon, Aug 20, 2007 at 10:17:14PM -0700, Ben Perrault wrote:
>          ->  Nested Loop  (cost=100000000.00..106559138.00 rows=336
> width=137)

This sounds very much like you're trying to force the planner. Did you set
enable_nestloop=false or something? Are there any other non-default settings
that could negatively impact planner performance?

/* Steinar */
--
Homepage: http://www.sesse.net/

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Optimising "in" queries
Следующее
От: "vincent"
Дата:
Сообщение: Re: Poor Performance after Upgrade