Re: skip replication slot snapshot/map file removal during end-of-recovery checkpoint

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Re: skip replication slot snapshot/map file removal during end-of-recovery checkpoint
Дата
Msg-id CALj2ACWiWOLWZwAS+gtq+VF-cifFr5NrZJcvhf3WdX=HHdqYoQ@mail.gmail.com
обсуждение исходный текст
Ответ на skip replication slot snapshot/map file removal during end-of-recovery checkpoint  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Ответы Re: skip replication slot snapshot/map file removal during end-of-recovery checkpoint  ("Bossart, Nathan" <bossartn@amazon.com>)
Список pgsql-hackers
Дерево обсуждения 
On Thu, Dec 23, 2021 at 4:46 PM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
>
> Hi,
>
> Currently the end-of-recovery checkpoint can be much slower, impacting
> the server availability, if there are many replication slot files
> XXXX.snap or map-XXXX to be enumerated and deleted. How about skipping
> the .snap and map- file handling during the end-of-recovery
> checkpoint? It makes the server available faster and the next regular
> checkpoint can deal with these files. If required, we can have a GUC
> (skip_replication_slot_file_handling or some other better name) to
> control this default being the existing behavior.
>
> Thoughts?

Here's the v1 patch, please review it.

Regards,
Bharath Rupireddy.
Вложения

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

Предыдущее
От: "tanghy.fnst@fujitsu.com"
Дата:
Сообщение: RE: [PATCH]Comment improvement in publication.sql
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: add checkpoint stats of snapshot and mapping files of pg_logical dir