Marc Mamin <M.Mamin@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
