Re: vacuum_cost_page_miss default value and modern hardware

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: vacuum_cost_page_miss default value and modern hardware
Дата
Msg-id CAH2-WzmYs3weR3nNkVu13dEn2B8jpuF9J_8YPF1hsPsko5wZBw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: vacuum_cost_page_miss default value and modern hardware  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers
On Wed, Jan 6, 2021 at 5:39 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> Perhaps you meant to decrease vacuumm_cost_page_miss instead of
> vacuum_cost_page_dirty?

You're right. Evidently I didn't write this email very carefully.
Sorry about that.

To say it again: I think that a miss (without dirtying the page)
should be cheaper than dirtying a page. This thread began because I
wanted to discuss the relative cost of different kinds of I/O
operations to VACUUM, without necessarily discussing the absolute
costs/time delays.

-- 
Peter Geoghegan



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

Предыдущее
От: "tsunakawa.takay@fujitsu.com"
Дата:
Сообщение: RE: Enhance traceability of wal_level changes for backup management
Следующее
От: Zhihong Yu
Дата:
Сообщение: Re: Transactions involving multiple postgres foreign servers, take 2