From: Tom Lane <tgl@sss.pgh.pa.us>
To: rverghese <riyav@hotmail.com>
cc: pgsql-performance@postgresql.org
Subject: Re: -EXT-Re: Table not using tsvector gin index and performance much
 worse than when it uses it.
In-reply-to: <1491438412093-5954509.post@n3.nabble.com>
References: <1491432671098-5954485.post@n3.nabble.com>
 <5326.1491434397@sss.pgh.pa.us> <1491436440096-5954503.post@n3.nabble.com>
 <fb871f19d7894a0cb5e60c7dfac17534@TOREXCPWP03.ga.com>
 <1491438412093-5954509.post@n3.nabble.com>
Comments: In-reply-to rverghese <riyav@hotmail.com>
	message dated "Wed, 05 Apr 2017 17:26:52 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <10941.1491440905.1@sss.pgh.pa.us>
Date: Wed, 05 Apr 2017 21:08:25 -0400
Message-ID: <10942.1491440905@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance