Use fadvise in wal replay

Поиск
Список
Период
Сортировка
От Kirill Reshke
Тема Use fadvise in wal replay
Дата
Msg-id CADVKa1WsQMBYK_02_Ji=pbOFnms+CT7TV6qJxDdHsFCiC9V_hw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Use fadvise in wal replay  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Hi hackers!

Recently we faced a problem with one of our production clusters. We use a cascade replication setup in this cluster, that is: master, standby (r1), and cascade standby (r2). From time to time, the replication lag on r1 used to grow, while on r2 it did not. Analysys showed that r1 startup process was spending a lot of time in reading wal from disk. Increasing /sys/block/md2/queue/read_ahead_kb to 16384 (from 0) helps in this case. Maybe we can add fadvise call in postgresql startup, so it would not be necessary to change settings on the hypervisor?
Вложения

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

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Replica Identity check of partition table on subscriber
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?