> -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
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
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
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