Do checkpoints flush all data from shared buffers ?

Поиск
Список
Период
Сортировка
От Fabrice Franquenk
Тема Do checkpoints flush all data from shared buffers ?
Дата
Msg-id 44AE2E53.2020406@bull.net
обсуждение исходный текст
Список pgsql-general
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-general по дате отправления:

Предыдущее
От: DANTE Alexandra
Дата:
Сообщение: VACUUM and fsm_max_pages
Следующее
От: Roman Neuhauser
Дата:
Сообщение: Re: Version/Change Management of functions?