Re: issue with gininsert under very high load - Mailing list pgsql-hackers

From Tom Lane
Subject Re: issue with gininsert under very high load
Date
Msg-id 30461.1392335361@sss.pgh.pa.us
Whole thread Raw
In response to Re: issue with gininsert under very high load  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: issue with gininsert under very high load  (Andres Freund <andres@2ndquadrant.com>)
Re: issue with gininsert under very high load  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-02-13 16:15:42 -0500, Tom Lane wrote:
>> Something like the attached?  Can somebody who's seen this problem confirm
>> this improves matters?

> Hm. Won't that possiby lead to the fast tuple list growing unboundedly?
> I think we would need to at least need to stop using the fast tuple
> mechanism during gininsert() if it's already too big and do plain
> inserts.

No, because we've already got a process working on cleaning it out.

In any case, this needs some testing to see if it's an improvement
or not.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Another pgindent gripe
Next
From: Andres Freund
Date:
Subject: Re: issue with gininsert under very high load