Re: Double-writes, take two?

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: Double-writes, take two?
Дата
Msg-id alpine.DEB.2.20.1804181135520.8472@lancre
обсуждение исходный текст
Ответ на Double-writes, take two?  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Double-writes, take two?  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Bonjour Michaël,

> - double-write buffers use a pre-decided numbers of pages (32 for the
> checkpointer, 128 divided into 4 buckets for the backends), which are
> synced into disk once each batch is full.

> - The double-write file of the checkpointer uses ordering of pages using
> blocks number and files to minimize the number of syncs to happen, using
> a custom sequential I/O algorithm.

I'm not sure from reading the descriptions.

Are these particular features related/similar to 9cd00c4 "Checkpoint 
sorting and balancing" and 428b1d6 "Allow to trigger kernel writeback 
after a configurable number of writes", committed in February 2016?

-- 
Fabien.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: Should we add GUCs to allow partition pruning to be disabled?
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Fix for documentation of Covering Indexes