Re: Postgresql 8.2.4 on linux-sparc problem

Поиск
Список
Период
Сортировка
Искать
От
Lew
Тема
Re: Postgresql 8.2.4 on linux-sparc problem
Дата
Msg-id
msadnT-NJv7XvRTanZ2dnUVZ_t2inZ2d@comcast.com
Ответ на
Список
Дерево обсуждения
Postgresql 8.2.4 on linux-sparc problem Zelinskiy Alexander <alexander.zelinskiy@gmail.com>
Re: Postgresql 8.2.4 on linux-sparc problem Tom Lane <tgl@sss.pgh.pa.us>
Re: Postgresql 8.2.4 on linux-sparc problem Zelinskiy Alexander <alexander.zelinskiy@gmail.com>
Re: Postgresql 8.2.4 on linux-sparc problem Tom Lane <tgl@sss.pgh.pa.us>
Re: Postgresql 8.2.4 on linux-sparc problem Lew <lew@lwsc.ehost-services.com>
Re: Postgresql 8.2.4 on linux-sparc problem Lew <lew@lwsc.ehost-services.com>
Tom Lane wrote:
> Before you get into that, try reducing these parameters:
> 
>> maintenance_work_mem = 1572864	
>> work_mem = 1048576
> 
> They are way too high, especially the second one.

So if 1.5 MB maintenance_work_mem and 1 MB work_mem are "way too high", why 
are the default values in the postgresql.conf on installation 16 MB and 1 MB, 
respectively?

-- 
Lew
В списке pgsql-general по дате отправления
От: dterrors@hotmail.com
Дата:
От: Tristen Ennemuist
Дата:
Сообщение: libpq updateable resultset?
FAQ