| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Avoiding pin scan during btree vacuum |
| Date: | 2016-01-04 08:45:09 |
| Message-ID: | 20160104084509.dvxkzh4tdzcfbayv@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2016-01-04 08:49:39 | Re: WIP: Covering + unique indexes. |
| Previous Message | Andres Freund | 2016-01-04 08:32:33 | Re: Some 9.5beta2 backend processes not terminating properly? |