Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it. - Mailing list pgsql-performance

From Tom Lane
Subject Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
Date
Msg-id 10942.1491440905@sss.pgh.pa.us
Whole thread Raw
In response to Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it uses it.  (rverghese <riyav@hotmail.com>)
Responses Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it uses it.  (rverghese <riyav@hotmail.com>)
List pgsql-performance
rverghese <riyav@hotmail.com> writes:
> Will play around with those settings as well. Maybe start with default which
> is 50 I believe.

If you're on 9.5, auto-analyze does not result in a pending list flush,
so it's irrelevant to fixing your problem.  (Assuming I've identified
the problem correctly.)  But you do have gin_pending_list_limit, so see
what that does for you.  Note you can set it either globally or per-index.

            regards, tom lane


pgsql-performance by date:

Previous
From: rverghese
Date:
Subject: Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it uses it.
Next
From: rverghese
Date:
Subject: Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it uses it.