What is the most optimal config parameters to keep stable write TPS ?..

From: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: What is the most optimal config parameters to keep stable write TPS ?..
Date: 2009-05-11 16:15:13
Message-ID: 5482c80a0905110915q6064d514h9fba1493bf603397@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-performance

Hi,

what may you suggest as the most optimal postgresql.conf to keep
writing as stable as possible?..

What I want is to avoid "throughput waves" - I want to keep my
response times stable without any activity holes. I've tried to reduce
checkpoint timeout from 5min to 30sec - it helped, throughput is more
stable now, but instead of big waves I have now short waves anyway..

What is the best options combination here?..

Rgds,
-Dimitri

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2009-05-11 16:19:39 Re: What is the most optimal config parameters tokeep stable write TPS ?..
Previous Message Stefan Kaltenbrunner 2009-05-11 16:05:25 Re: PostgreSQL with PostGIS on embedded hardware