From: Christian Paul B. Cosinas <cpc@cybees.com>
To: pgsql-performance@postgresql.org
Subject: FW: Used Memory
Date: Tue, 25 Oct 2005 07:28:51 -0000
Message-ID: <001701c5d935$bfc21970$1e21100a@ghwk02002147> (raw)
Here are the configuration of our database server:
port = 5432
max_connections = 300
superuser_reserved_connections = 10
authentication_timeout = 60
shared_buffers = 48000
sort_mem = 32168
sync = false
Do you think this is enough? Or can you recommend a better configuration for
my server?
The server is also running PHP and Apache but wer'e not using it
extensively. For development purpose only.
The database slow down is occurring most of the time (when the memory free
is low) I don't think it has something to do with vacuum. We only have a
full server vacuum once a day.
I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cpc@cybees.com
Subject: Re: FW: Used Memory
In-Reply-To: <001701c5d935$bfc21970$1e21100a@ghwk02002147>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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