Re: gin performance issue. - Mailing list pgsql-performance

From Tom Lane
Subject Re: gin performance issue.
Date
Msg-id 12466.1454684837@sss.pgh.pa.us
Whole thread Raw
In response to gin performance issue.  (Marc Mamin <M.Mamin@intershop.de>)
Responses Re: gin performance issue.  (Marc Mamin <M.Mamin@intershop.de>)
List pgsql-performance
Marc Mamin <M.Mamin@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


pgsql-performance by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: bad COPY performance with NOTIFY in a trigger
Next
From: Filip Rembiałkowski
Date:
Subject: Re: bad COPY performance with NOTIFY in a trigger