Re: Shared_buffer limited by SO

Поиск
Список
Период
Сортировка
От Fábio Gibon - Comex System
Тема Re: Shared_buffer limited by SO
Дата
Msg-id 002401cbf925$be99ae80$eb3074bb@gibon
обсуждение исходный текст
Ответ на Shared_buffer limited by SO  (Fábio Gibon - Comex System<gibon@comexsystem.com.br>)
Список pgsql-admin
> Fábio Gibon - Comex System<gibon@comexsystem.com.br> wrote:
>
>> are there how define high more than 512Mb to shared_buffer on
>> windows?
>
> What happens when you set it higher than that?

Database don't start e show this message (português):
2011-04-12 12:10:22 BRT FATAL:  não pôde criar segmento de memória
compartilhada: 8 (can't create a shared memory segment)
2011-04-12 12:10:22 BRT DETALHE:  Falhou ao executar chamada de sistema
MapViewOfFileEx. (fail on run system call mapviewoffileex, or like this...)

>
> Also, it would be useful to know the version of PostgreSQL, the
> version of Windows, the amount of RAM on the system, etc.
Windows Server 2003 - Standard Edition - SP1 - 32bits
PostgreSQL 8.4.3
RAM 4GB
This error ocurred when I try set shared_buffers to 1GB, with 768MB work
fine.


>
> -Kevin
>


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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: ubuntu swap space
Следующее
От: "Donald Fraser"
Дата:
Сообщение: Re: Missing documentation for error code: 80S01