Re: Incremental checkopints

Поиск
Список
Период
Сортировка
От jordani@go-link.net
Тема Re: Incremental checkopints
Дата
Msg-id 5122746bc3b5a016d33c118f882bfa2b.squirrel@mail.go-link.net
обсуждение исходный текст
Ответ на Incremental checkopints  (jordani@go-link.net)
Список pgsql-hackers
> If you make writes go out more often, they will be less efficient

I think fsync is more important. But many writes + fsync is no good too.
Let suppose that 30 WAL segments are good for performance (to be written
at once). In incremental approach we can have 60 segments and we can write
30 at once. There is no checkpoint_timeout - more buffers will stay more
time.

I can not see any disadvantage.

Jordan Ivanov



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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Reduced power consumption in autovacuum launcher process
Следующее
От: Nikhil Sontakke
Дата:
Сообщение: Re: Check constraints on partition parents only?