Re: FSM versus GIN pending list bloat - Mailing list pgsql-hackers

From Tom Lane
Subject Re: FSM versus GIN pending list bloat
Date
Msg-id 27036.1438702155@sss.pgh.pa.us
Whole thread Raw
In response to Re: FSM versus GIN pending list bloat  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> On 4 August 2015 at 15:18, Andres Freund <andres@anarazel.de> wrote:
>> The only thing that variable does is change what the pending size limit
>> is determined by. Previously it was work_mem, now it's
>> gin_pending_list_limit. Imo that has pretty much nothing to do with not
>> registering pages as free.

> We've made a change to the way GIN fast update works and that needs to be
> an effective change, not one that immediately triggers a secondary
> annoyance for the user.

Said annoyance has been there since day one, no?

> I've asked some questions; they may turn into
> actions, or not, but they are open items.

If it's not a new problem introduced by 9.5, I don't think it's
appropriate to insist that 9.5 must solve it.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Autonomous Transaction is back
Next
From: Robert Haas
Date:
Subject: Re: Reduce ProcArrayLock contention