From: "Shiv Sharma" <shiv.sharma.1835@gmail.com> To: "SUNDAY A. OLUTAYO" <olutayo@sadeeb.com> Cc: pgsql-novice@postgresql.org Sent: Friday, December 27, 2013 9:41:58 PM Subject: Re: [NOVICE] Checkpoint versus Background Writer
>Checkpoint is different to background writer though works together >BGW continuously write buffer to disk but checkpoint is interval default to 5min at which the process call >BGW to flush the entire buffer to disk
But with 8.3 and checkpoint_completion_target, is not the checkpoint spread out too? (or can be spread out).
On Fri, Dec 27, 2013 at 10:58 AM, SUNDAY A. OLUTAYO <olutayo@sadeeb.com> wrote:
Checkpoint is different to background writer though works together BGW continuously write buffer to disk but checkpoint is interval default to 5min at which the process call BGW to flush the entire buffer to disk