Re: question about memory usage

Поиск
Список
Период
Сортировка
От klo uo
Тема Re: question about memory usage
Дата
Msg-id CAA-8Ld8Q3_40jLR-ZNnxXGyBtgRZiTS2MEkXO_bwVgdRSR47bg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: question about memory usage  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: question about memory usage  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-general
Bill, thanks for your reply.

"shared_buffers" is set to "128MB".

Now that you mention config file, the only thing I did change there, and was suggested to me while I made some on my databases was "max_locks_per_transaction = 50000" (which has default value 10000).

After resetting "max_locks_per_transaction" to default value and restarting the server, memory occupied in working set reduced linearly to around 200 MB.

I guess this is it.


On Wed, Jul 23, 2014 at 5:53 AM, Bill Moran <wmoran@potentialtech.com> wrote:

I'm not an expert on the Windows version, so I could be off-base, but the
POSIX versions of Postgres allocate shared_buffers worth of memory at startup
and lock it for exclusive use by Postgres.  Do you have shared_buffers set to
around 1G, perhaps?


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

Предыдущее
От: Rebecca Clarke
Дата:
Сообщение: Index usage with slow query
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: