From: | Mark Rinaudo <mark(at)bowmansystems(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Postgresql on an AMD64 machine |
Date: | 2005-06-06 17:53:40 |
Message-ID: | 1118080420.1644.23.camel@penguin1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
I'm not sure if this is the appropriate list to post this question to
but i'm starting with this one because it is related to the performance
of Postgresql server. I have a Penguin Computing dual AMD 64 bit
opteron machine with 8 Gigs of memory. In my attempt to increase the
number of shared_buffers from the default to 65000 i was running into a
semget error when trying to start Postgresql. After reading the
documentation I adjusted the semaphore settings in the kernel to allow
Postgresql to start successfully. With this configuration running if I
do a ipcs -u i get the following.
------ Shared Memory Status --------
segments allocated 1
pages allocated 30728
pages resident 30626
pages swapped 0
Swap performance: 0 attempts 0 successes
------ Semaphore Status --------
used arrays = 1880
allocated semaphores = 31928
------ Messages: Status --------
allocated queues = 0
used headers = 0
used space = 0 bytes
I'm questioning the number of semaphores being used. In order for
postgresql to start I had to set the maximum number of semaphores system
wide to 6000000. This seems to be an abnormal amount of semaphores. I'm
curious if this is a bug in the amd64 postgresql port. Is anyone else
using postgresql on an AMD64 machine without similar issues?
TIA
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | PFC | 2005-06-06 18:12:11 | Re: Need help to decide Mysql vs Postgres |
Previous Message | Michael Stone | 2005-06-06 17:27:40 | Re: Performance nightmare with dspam (urgent) (resolved) |