Re: FSM versus GIN pending list bloat

On 4 August 2015 at 15:18, Andres Freund <andres(at)anarazel(dot)de> wrote:

> On 2015-08-04 14:59:11 +0100, Simon Riggs wrote:
> > On 4 August 2015 at 14:55, Heikki Linnakangas <hlinnaka(at)iki(dot)fi> wrote:
> >
> > > On 08/04/2015 04:35 PM, Simon Riggs wrote:
> > >
> > >> This and the OP seem like 9.5 open items to me.
> > >>
> > >
> > > Why? This is nothing new in 9.5.
> >
> >
> > gin_pending_list_limit is new in 9.5
> >
> > We're in Alpha, so if something has been added and isn't very usable, we
> > should change it while we can.
>
> 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. I've asked some questions; they may turn into
actions, or not, but they are open items.

--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services