From: Tom Lane <tgl@sss.pgh.pa.us>
To: FERREIRA, William (VALTECH) <william.ferreira@airbus.com>
Cc: J.K.Shah@Sun.COM, Albert Cervera Areny <albert@sedifa.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: copy and postgresql.conf
Date: Wed, 15 Feb 2006 10:18:18 -0500
Message-ID: <196.1140016698@sss.pgh.pa.us> (raw)
In-Reply-To: <414D259CE29DE54DAD534037C83CE4B7011E4874@FR0-MAILMB20.res.airbus.corp>
References: <414D259CE29DE54DAD534037C83CE4B7011E4874@FR0-MAILMB20.res.airbus.corp>
"FERREIRA, William (VALTECH)" <william.ferreira@airbus.com> writes:
> with PostgreSQL 8.1.3, here are my parameters (it's the default configuration)
> wal_sync_method = fsync
> wal_buffers = 8
> checkpoint_segments = 3
> bgwriter_lru_percent = 1.0
> bgwriter_lru_maxpages = 5
> bgwriter_all_percent = 0.333
> bgwriter_all_maxpages = 5
> and you think times can be improved again ?
Increasing checkpoint_segments will definitely help for any write-intensive
situation. It costs you in disk space of course, as well as the time
needed for post-crash recovery.
regards, tom lane
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: tgl@sss.pgh.pa.us, william.ferreira@airbus.com, albert@sedifa.com
Subject: Re: copy and postgresql.conf
In-Reply-To: <196.1140016698@sss.pgh.pa.us>
* 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