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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rverghese <riyav(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
Date: 2017-04-06 01:08:25
Message-ID: 10942.1491440905@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

rverghese <riyav(at)hotmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message rverghese 2017-04-06 01:10:56 Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.
Previous Message rverghese 2017-04-06 00:26:52 Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.