Marc Mamin <m.ma...@intershop.de> writes:
> http://explain.depesz.com/s/wKv7
> Postgres Version 9.3.10 (Linux)
> Hello,
> this is a large daily table that only get bulk inserts (200-400 /days) with
> no update.
> After rebuilding the whole table, the Bitmap Index Scan on
> r_20160204_ix_toprid falls under 1 second (from 800)
> Fastupdate is using the default, but autovacuum is disabled on that table
> which contains 30 Mio rows.
Pre-9.5, it's a pretty bad idea to disable autovacuum on a GIN index,
because then the "pending list" only gets flushed when it exceeds
work_mem. (Obviously, using a large work_mem setting makes this worse.)
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
