Re: gin performance issue.

From: Tom Lane
Subject: Re: gin performance issue.
Date: ,
Msg-id: 12466.1454684837@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: gin performance issue.  (Marc Mamin)
Responses: Re: gin performance issue.  (Marc Mamin)
List: pgsql-performance

Tree view

gin performance issue.  (Marc Mamin, )
 Re: gin performance issue.  (Tom Lane, )
  Re: gin performance issue.  (Marc Mamin, )
   Re: gin performance issue.  (Jeff Janes, )

Marc Mamin <> 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:

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