pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedShared_buffer limited by SO
3+ messages / 2 participants
[nested] [flat]
* Shared_buffer limited by SO
@ 2011-04-12 12:07 Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2011-04-12 14:19 ` Re: Shared_buffer limited by SO Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 3+ messages in thread
From: Fábio Gibon - Comex System @ 2011-04-12 12:07 UTC (permalink / raw)
To: pgsql-admin
Hi,
are there how define high more than 512Mb to shared_buffer on windows?
thanks
Fábio Henrique Gibon
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Shared_buffer limited by SO
2011-04-12 12:07 Shared_buffer limited by SO Fábio Gibon - Comex System <gibon@comexsystem.com.br>
@ 2011-04-12 14:19 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-04-12 15:24 ` Re: Shared_buffer limited by SO Fábio Gibon - Comex System <gibon@comexsystem.com.br>
0 siblings, 1 reply; 3+ messages in thread
From: Kevin Grittner @ 2011-04-12 14:19 UTC (permalink / raw)
To: 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?
Also, it would be useful to know the version of PostgreSQL, the
version of Windows, the amount of RAM on the system, etc.
-Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Shared_buffer limited by SO
2011-04-12 12:07 Shared_buffer limited by SO Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2011-04-12 14:19 ` Re: Shared_buffer limited by SO Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2011-04-12 15:24 ` Fábio Gibon - Comex System <gibon@comexsystem.com.br>
0 siblings, 0 replies; 3+ messages in thread
From: Fábio Gibon - Comex System @ 2011-04-12 15:24 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-04-12 15:24 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-12 12:07 Shared_buffer limited by SO Fábio Gibon - Comex System <gibon@comexsystem.com.br>
2011-04-12 14:19 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-04-12 15:24 ` Fábio Gibon - Comex System <gibon@comexsystem.com.br>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox