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?..
pgsql-performance by date
|Next:||From: Kevin Grittner||Date: 2009-05-11 16:19:39|
|Subject: Re: What is the most optimal config parameters tokeep stable write TPS ?..|
|Previous:||From: Stefan Kaltenbrunner||Date: 2009-05-11 16:05:25|
|Subject: Re: PostgreSQL with PostGIS on embedded hardware|