From: Mark Lonsdale <mark.lonsdale@wysdm.com>
To: pgsql-performance@postgresql.org
Subject: Configuration Issue ?
Date: Wed, 25 Oct 2006 16:47:50 -0400
Message-ID: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A84@mail3> (raw)
Hi
Please help. I have got a postgres 7.3.4 database running on RedHat ES
3, with 8GB of physical memory in it. The machine is shared with my
application which is pretty intensive in doing selects and updates
against the database, but there are usually no more than 10 connections
to the database at any time.
Despite having 8GB of RAM on the machine, the machine is frequently
running out of physical memory and swapping which is hurting
performance. Have read around on various of the message boards, and I
suspect that the SHARED_BUFFERS setting on this server is set way to
high, and that this in fact may be hurting performance. My current
configuration settings are as follows:
shared_buffers = 393216 # min max_connections*2 or 16, 8KB each
max_fsm_relations = 10000 # min 10, fsm is free space map, ~40
bytes
max_fsm_pages = 160001 # min 1000, fsm is free space map, ~6
bytes
sort_mem = 409600 # min 64, size in KB
vacuum_mem = 81920 # min 1024, size in KB
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: mark.lonsdale@wysdm.com
Subject: Re: Configuration Issue ?
In-Reply-To: <673ECBB77DA91F47AD4902A5FD73BCE4BA3A84@mail3>
* 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