Do checkpoints flush all data from shared buffers ? - Mailing list pgsql-novice

From Fabrice Franquenk
Subject Do checkpoints flush all data from shared buffers ?
Date
Msg-id 44AB8894.6060204@bull.net
Whole thread Raw
Responses Re: Do checkpoints flush all data from shared buffers ?
Re: Do checkpoints flush all data from shared buffers ?
List pgsql-novice
Hello,
    I was wondering if each checkpoint would flush all transactions from
the shared buffers or if there could be some left at the end of the
checkpoint ?
Because i was trying to lower I/Os of the disks, i got the checkpoint
timeout lowered to 150 seconds so i get twice the number the checkpoint.
I was hoping it would reduce the number of  I/Os on the disks because
there would be less data to write in datafiles...

Thanks in advance for your help

regards,
             Fabrice Franquenk

pgsql-novice by date:

Previous
From: Fabrice Franquenk
Date:
Subject: Re: WAL Internals question
Next
From: Justus Mugbeh
Date:
Subject: Help!