Re: [PERFORM] gin performance issue.

2016-02-08 Thread Marc Mamin
> -Original Message- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Freitag, 5. Februar 2016 16:07 > > 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

Re: [PERFORM] gin performance issue.

2016-02-08 Thread Jeff Janes
On Mon, Feb 8, 2016 at 2:21 AM, Marc Mamin wrote: > > - auto vacuum will not run as these are insert only tables > - according to this post, auto analyze would also do the job: > > http://postgresql.nabble.com/Performance-problem-with-gin-index-td5867870.html > It seems

Re: [PERFORM] gin performance issue.

2016-02-05 Thread Tom Lane
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

[PERFORM] gin performance issue.

2016-02-05 Thread Marc Mamin
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