Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

Поиск
Список
Период
Сортировка
От Gunnar \"Nick\" Bluth
Тема Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Дата
Msg-id 50997077.1020500@pro-open.de
обсуждение исходный текст
Ответ на Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries  (Petr Praus <petr@praus.net>)
Ответы Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries  (Petr Praus <petr@praus.net>)
Список pgsql-performance
Am 06.11.2012 21:08, schrieb Petr Praus:
>
> 2MB: http://explain.depesz.com/s/ul1
> 4MB: http://explain.depesz.com/s/IlVu
> 10MB: http://explain.depesz.com/s/afx3
> 12MB: http://explain.depesz.com/s/i0vQ
>
See the change in the plan between 10MB and 12MB, directly at top level?
That narrows the thing down quite a bit.

Though I wonder why this didn't show in the original plans...

--
Gunnar "Nick" Bluth
RHCE/SCLA

Mobil   +49 172 8853339
Email: gunnar.bluth@pro-open.de
__________________________________________________________________________
In 1984 mainstream users were choosing VMS over UNIX.  Ten years later
they are choosing Windows over UNIX.  What part of that message aren't you
getting? - Tom Payne



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2
Следующее
От: "Gunnar \"Nick\" Bluth"
Дата:
Сообщение: Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries