From: Pallav Kalva <pkalva@deg.cc>
To: Postgres Performance <pgsql-performance@postgresql.org>
Subject: Very Bad Performance.
Date: Mon, 03 Jan 2005 17:19:15 -0500
Message-ID: <41D9C4E3.3050001@deg.cc> (raw)
Hi ,
I am experiencing a very bad performance on my production database
lately , all my queries are slowing down. Our application is a webbased
system with lot of selects and updates. I am running "vacuumdb" daily on
all the databases, are the below postgres configuration parameters are
set properly ? can anyone take a look. Let me know if you need anymore
information.
Postgres Version: 7.4
Operating System: Linux Red Hat 9
Cpus: 2 Hyperthreaded
RAM: 4 gb
Postgres Settings:
max_fsm_pages | 20000
max_fsm_relations | 1000
shared_buffers | 65536
sort_mem | 16384
vacuum_mem | 32768
wal_buffers | 64
effective_cache_size | 393216
Thanks!
Pallav
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: pkalva@deg.cc
Subject: Re: Very Bad Performance.
In-Reply-To: <41D9C4E3.3050001@deg.cc>
* 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