From: selvi88 <selvi.dct@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: postgres performance tunning
Date: Sat, 18 Dec 2010 01:34:42 -0800 (PST)
Message-ID: <1292664882937-3310337.post@n5.nabble.com> (raw)
In-Reply-To: <4D0B6393.8010400@2ndquadrant.com>
References: <1292502787617-3307846.post@n5.nabble.com>
<4D0B6393.8010400@2ndquadrant.com>
Thanks for ur suggestion, already I have gone through that url, with that
help I was able to make my configuration to work for 5K queries/second.
The parameters I changed was shared_buffer, work_mem, maintenance_work_mem
and effective_cache.
Still I was not able to reach my target.
Can u kindly tell me ur postgres configurations thereby I can get some idea
out of it.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/postgres-performance-tunning-tp3307846p3310337.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
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: selvi.dct@gmail.com
Subject: Re: postgres performance tunning
In-Reply-To: <1292664882937-3310337.post@n5.nabble.com>
* 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