Re: postgres performance tunning - Mailing list pgsql-performance

From selvi88
Subject Re: postgres performance tunning
Date
Msg-id 1292664882937-3310337.post@n5.nabble.com
Whole thread Raw
In response to Re: postgres performance tunning  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: postgres performance tunning  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-performance

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.

pgsql-performance by date:

Previous
From: selvi88
Date:
Subject: Re: postgres performance tunning
Next
From: Jim Nasby
Date:
Subject: Re: Strange optimization - xmin,xmax compression :)