What is the most optimal config parameters to keep stable write TPS ?.. - Mailing list pgsql-performance

From Dimitri
Subject What is the most optimal config parameters to keep stable write TPS ?..
Date
Msg-id 5482c80a0905110915q6064d514h9fba1493bf603397@mail.gmail.com
Whole thread Raw
Responses Re: What is the most optimal config parameters to keep stable write TPS ?..
Re: What is the most optimal config parameters to keep stable write TPS ?..
List 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

pgsql-performance by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: PostgreSQL with PostGIS on embedded hardware
Next
From: "Kevin Grittner"
Date:
Subject: Re: What is the most optimal config parameters to keep stable write TPS ?..