Request a Demo
Home   >   mailing lists

Optimize SnapBuildPurgeOlderTxn to purge committed xids in-place - Mailing list pgsql-hackers

From Neil Chen
Subject Optimize SnapBuildPurgeOlderTxn to purge committed xids in-place
Date
Msg-id CAA3qoJm+R03tzF_2p4Syck4Nwx1dGBsusN25frGx4NGnT_ck2Q@mail.gmail.com
Whole thread Raw
Responses Re: Optimize SnapBuildPurgeOlderTxn to purge committed xids in-place
List pgsql-hackers
Tree view
Hi all,

While reading the code of SnapBuildPurgeOlderTxn, I noticed the TODO comment suggesting a neater algorithm instead of using a temporary workspace for copying committed xids.

I’ve implemented an in-place purge approach for the committed xid array to eliminate the overhead of memory allocation and data copying.
 
Tested locally without issues—happy to hear your thoughts.
Attachment

pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Fwd: pg18 bug? SELECT query doesn't work
Next
From: Japin Li
Date:
Subject: Re: Pasword expiration warning