Re: FATAL: could not read statistics message

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: FATAL: could not read statistics message
Дата
Msg-id 20060516205617.GY26212@pervasive.com
обсуждение исходный текст
Ответ на Re: FATAL: could not read statistics message  (Sean Davis <sdavis2@mail.nih.gov>)
Ответы Re: FATAL: could not read statistics message  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-general
On Tue, May 16, 2006 at 03:41:07PM -0400, Sean Davis wrote:
> I had cranked things up a bit from the standard install.
>
> shared_buffers = 15000                  # min 16 or max_connections*2, 8KB
> each
> #temp_buffers = 1000                    # min 100, 8KB each
> #max_prepared_transactions = 50         # can be 0 or more
> work_mem = 10000                        # min 64, size in KB
> maintenance_work_mem = 128000           # min 1024, size in KB
> max_stack_depth = 4096                  # min 100, size in KB

You didn't say anything about how much memory you have, but you need to
be careful with *work_mem, as being too agressive can run the machine
out of memory.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: problems with postgresql 9
Следующее
От: Don Y
Дата:
Сообщение: Type checking