Postgres Pro
Downloads
Home   >   mailing lists

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

From Bharath Rupireddy
Subject skip replication slot snapshot/map file removal during end-of-recovery checkpoint
Date
Msg-id CALj2ACXkkSL8EBpR7m=Mt=yRGBhevcCs3x4fsp3Bc-D13yyHOg@mail.gmail.com
Whole thread Raw
Responses Re: skip replication slot snapshot/map file removal during end-of-recovery checkpoint  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
List pgsql-hackers
Tree view 
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?

Regards,
Bharath Rupireddy.

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Logical replication timeout problem
Next
From: Bharath Rupireddy
Date:
Subject: correct the sizes of values and nulls arrays in pg_control_checkpoint