Re: Win32 Backend Cash - pre-existing shared memory block is still in use

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Win32 Backend Cash - pre-existing shared memory block is still in use
Дата
Msg-id 12542.1282713799@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Win32 Backend Cash - pre-existing shared memory block is still in use  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Win32 Backend Cash - pre-existing shared memory block is still in use  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Win32 Backend Cash - pre-existing shared memory block is still in use  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Scott Marlowe <scott.marlowe@gmail.com> writes:
> 512M is still REALLY high for a 32 bit postgresql.  Have you tried
> something in the 16Meg range?

Cutting his value for shared_buffers (currently about 800MB) might be
wise too.  I'm not sure what the effectively available address space
for a win32 process is, but if there's any inefficiency in the way
the address space is laid out, those numbers could be enough to be
trouble.

            regards, tom lane

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

Предыдущее
От: Jeremy Palmer
Дата:
Сообщение: Re: Win32 Backend Cash - pre-existing shared memory block is still in use
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Win32 Backend Cash - pre-existing shared memory block is still in use