Re: Reduce pinning in btree indexes - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Reduce pinning in btree indexes
Date
Msg-id CA+U5nMKCJ1gvPkzqmFOP7k_4pgFfLz1bSm78pWSm+RKfmBUxwg@mail.gmail.com
Whole thread Raw
In response to Re: Reduce pinning in btree indexes  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-hackers
On 4 March 2015 at 03:16, Kevin Grittner <kgrittn@ymail.com> wrote:

> How do people feel about the idea of me pushing this for 9.5 (after
> I clean up all the affected comments and README files)?  I know
> this first appeared in the last CF, but the footprint is fairly
> small and the only user-visible behavior change is that a btree
> index scan of a WAL-logged table using an MVCC snapshot no longer
> blocks a vacuum indefinitely.  (If there are objections I will move
> this to the first CF for the next release.)

It helps Hot Standby also, BTW. I proposed this previously, but it was
shot down, so I'm glad to see it happening.

I'm not sure why you have proposed only half the solution though?
Hopefully we aren't just submitting the difficult half that you needed
feedback on? Let's see the whole "snapshot too old" patch as well,
since that affects core PostgresSQL also.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, RemoteDBA, Training &
Services



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: forward vs backward slashes in msvc build code
Next
From: Sreerama Manoj
Date:
Subject: Regarding pg_stat_statements