Re: Avoiding pin scan during btree vacuum - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Avoiding pin scan during btree vacuum
Date
Msg-id 20160104084509.dvxkzh4tdzcfbayv@alap3.anarazel.de
Whole thread Raw
In response to Re: Avoiding pin scan during btree vacuum  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Avoiding pin scan during btree vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 2016-01-03 15:40:01 +0000, Simon Riggs wrote:
> I'm happy with this being a simple patch now, not least because I would
> like to backpatch this to 9.4 where catalog scans became MVCC.
> 
> A backpatch is warranted because it is a severe performance issue with
> replication and we can fix that before 9.5 hits the streets.
> 
> I'll be doing some more testing and checking, so not in a rush.

This seems like a might subtle thing to backpatch. If we really want to
go there, ISTM that the relevant code should stew in an unreleased
branch for a while, before being backpatched.

Andres



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Some 9.5beta2 backend processes not terminating properly?
Next
From: David Rowley
Date:
Subject: Re: WIP: Covering + unique indexes.