Date: Wed, 5 Apr 2017 16:54:00 -0700 (MST)
From: rverghese <riyav@hotmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1491436440096-5954503.post@n3.nabble.com>
In-Reply-To: <5326.1491434397@sss.pgh.pa.us>
References: <1491432671098-5954485.post@n3.nabble.com>
 <5326.1491434397@sss.pgh.pa.us>
Subject: Re: Table not using tsvector gin index and performance much worse
 than when it uses it.
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Thanks for the response!

* We are on version 9.5.6

* Less than 10% of the table was updated today (between the time of the last
reindex to when performance deteriorated)

* autovacuum is on. I don't see an autoanalyze property in config but these
are the settings for analyze 
/autovacuum_analyze_threshold = 3000     # min number of row updates before 
analyze
#autovacuum_vacuum_scale_factor = 0.2   # fraction of table size before
vacuum
#autovacuum_analyze_scale_factor = 0.1  # fraction of table size before
analyze
#autovacuum_freeze_max_age = 200000000  # maximum XID age before forced
vacuum
                                        # (change requires restart)/

* And this #gin_pending_list_limit = 4MB 

* gin_clean_pending_list() is not available.

Will play with gin_pending_list_limit and see what that does. 

Thanks!
RV


--
View this message in context: http://www.postgresql-archive.org/Table-not-using-tsvector-gin-index-and-performance-much-worse-than-when-it-uses-it-tp5954485p5954503.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


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