Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <

From: Kevin Grittner <kgrittn(at)gmail(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Noah Misch <noah(at)leadboat(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Ants Aasma <ants(dot)aasma(at)eesti(dot)ee>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Kevin Grittner <kgrittn(at)postgresql(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Date: 2016-07-01 14:00:45
Message-ID: CACjxUsN4XBtG3G5NXm=JTtWBc+t5B9nQq77VV2CQJHxyuDUqyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Fri, Jul 1, 2016 at 7:17 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Fri, Jul 1, 2016 at 2:48 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
>>> This PostgreSQL 9.6 open item is past due for your status update. Kindly send
>>> a status update within 24 hours, and include a date for your subsequent status
>>> update. Refer to the policy on open item ownership:
>>> http://www.postgresql.org/message-id/20160527025039.GA447393@tornado.leadboat.com
>>
>> IIRC Kevin is out of the office this week, so this'll have to wait till
>> next week.
>
> No, he's back since Tuesday - it was last week that he was out. I
> spoke with him yesterday about this and he indicated that he had been
> thinking about it and had several ideas about how to fix it. I'm not
> sure why he hasn't posted here yet.

I have been looking at several possible fixes, and weighing the
pros and cons of each. I expect to post a patch later today.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2016-07-01 14:04:36 Re: pgsql: Fix crash bug in RestoreSnapshot.
Previous Message Simon Riggs 2016-07-01 13:34:52 Re: pgsql: Fix crash bug in RestoreSnapshot.

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-07-01 14:02:46 Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions
Previous Message Robert Haas 2016-07-01 13:58:14 Re: how is the WAL receiver process stopped and restarted when the network connection is broken and then restored?