Postgres Pro
Downloads
Home   >   mailing lists

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

From Bharath Rupireddy
Subject Re: skip replication slot snapshot/map file removal during end-of-recovery checkpoint
Date
Msg-id CALj2ACWiWOLWZwAS+gtq+VF-cifFr5NrZJcvhf3WdX=HHdqYoQ@mail.gmail.com
Whole thread Raw
In response to skip replication slot snapshot/map file removal during end-of-recovery checkpoint  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses Re: skip replication slot snapshot/map file removal during end-of-recovery checkpoint
List pgsql-hackers
Tree view 
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.
Attachment

pgsql-hackers by date:

Previous
From: "tanghy.fnst@fujitsu.com"
Date:
Subject: RE: [PATCH]Comment improvement in publication.sql
Next
From: Bharath Rupireddy
Date:
Subject: Re: add checkpoint stats of snapshot and mapping files of pg_logical dir