| From: | Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br> |
|---|---|
| To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, "PostgreSQL - mailing list" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Shared_buffer limited by SO |
| Date: | 2011-04-12 15:24:19 |
| Message-ID: | 002401cbf925$be99ae80$eb3074bb@gibon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> Fábio Gibon - Comex System<gibon(at)comexsystem(dot)com(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-04-12 15:24:25 | Re: ubuntu swap space |
| Previous Message | Tom Lane | 2011-04-12 14:52:55 | Re: Missing documentation for error code: 80S01 |