Re: Permance issues with migrated db

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Permance issues with migrated db
Дата
Msg-id 465340DD.10908@archonet.com
обсуждение исходный текст
Ответ на Re: Permance issues with migrated db  (Robert Fitzpatrick <lists@webtent.net>)
Ответы Re: Permance issues with migrated db  (Robert Fitzpatrick <lists@webtent.net>)
Список pgsql-general
Robert Fitzpatrick wrote:
> I did some googling and came up with some ideas, I have it now with
> these settings and after restarting PG, no help.
>
> work_mem = 5MB

My last post missed yours - you're ahead of my previous reply :-)

Try 32MB, then 64MB, then perhaps 128MB. If it looks like you're not
using stupid amounts of RAM on this one sort go higher still.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Permance issues with migrated db
Следующее
От: Robert Fitzpatrick
Дата:
Сообщение: Re: Permance issues with migrated db