Horton

Re: [PATCHES] GIN improvements

Teodor Sigaev <teodor@sigaev.ru>

View thread View on postgr.es
From: Teodor Sigaev <teodor@sigaev.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jeff Davis <pgsql@j-davis.com>, Robert Haas <robertmhaas@gmail.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2009-02-11T14:53:36Z
Lists: pgsql-hackers 
> But the real bottom line is: if autovacuum is working properly, it
> should clean up the index before the list ever gets to the point where
> it'd be sane to turn off indexscans.  So I don't see why we need to hack
> the planner for this at all.  If any hacking is needed, it should be
> in the direction of making sure autovacuum puts sufficient priority
> on this task.

Autovacuum will start if table has GIN index with fastupdate=on and number of 
inserted tuple since last vacuum > autovacuum_vacuum_threshold.
-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/