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

From: Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: skip replication slot snapshot/map file removal during end-of-recovery checkpoint
Date: 2021-12-23 11:16:02
Message-ID: CALj2ACXkkSL8EBpR7m=Mt=yRGBhevcCs3x4fsp3Bc-D13yyHOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2021-12-23 11:39:28 correct the sizes of values and nulls arrays in pg_control_checkpoint
Previous Message Amit Kapila 2021-12-23 10:51:58 Re: Logical replication timeout problem