Postgres Pro
Downloads
Home   >   mailing lists

Re: Deleting older versions in unique indexes to avoid page splits - Mailing list pgsql-hackers

From Victor Yegorov
Subject Re: Deleting older versions in unique indexes to avoid page splits
Date
Msg-id CAGnEboiVtEc88AEv8oXJ0XBWwQgSM7r2FM9j_ePpSuxAZ_ryJA@mail.gmail.com
Whole thread Raw
In response to Re: Deleting older versions in unique indexes to avoid page splits  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Deleting older versions in unique indexes to avoid page splits  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Tree view
чт, 12 нояб. 2020 г. в 23:00, Peter Geoghegan <pg@bowt.ie>:
Another thing that I'll probably add to v8: Prefetching. This is
probably necessary just so I can have parity with the existing
heapam.c function that the new code is based on,
heap_compute_xid_horizon_for_tuples(). That will probably help here,
too.

I don't quite see this part. Do you mean top_block_groups_favorable() here? 


--
Victor Yegorov

pgsql-hackers by date:

Previous
From: Victor Yegorov
Date:
Subject: Re: Deleting older versions in unique indexes to avoid page splits
Next
From: Ben Kanouse
Date:
Subject: ERROR: too many dynamic shared memory segment