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
patch submitted on -hackers list.
http://www.postgresql.org/message-id/CAP_rwwn2z0gPOn8GuQ3qDVS5+HgEcG2EzEOyiJtcA=vpdeh...@mail.gmail.com
results after the patch:
trigger= BEGIN RETURN NULL; END
rows=4
228ms COPY test.tab FROM '/tmp/test.dat'
205ms COPY test.tab FROM
On Mon, 1 Feb 2016 at 10:45 Tom Lane wrote:
> Mathieu De Zutter writes:
> Assuming you have a reasonably late-model PG, you could rewrite the
> view with a lateral function call:
>
> CREATE OR REPLACE VIEW covering_works_r AS
> SELECT
> w.id
Tom Lane writes:
> No surprise, see AsyncExistsPendingNotify. You would have a lot of other
> performance issues with sending hundreds of thousands of distinct notify
> events from one transaction anyway, so I can't get terribly excited about
> this.
@Filip: you probably
On Fri, Feb 5, 2016 at 9:33 AM, Filip Rembiałkowski
wrote:
> patch submitted on -hackers list.
> http://www.postgresql.org/message-id/CAP_rwwn2z0gPOn8GuQ3qDVS5+HgEcG2EzEOyiJtcA=vpdeh...@mail.gmail.com
>
> results after the patch:
>
> trigger= BEGIN RETURN NULL; END
On Thu, Feb 4, 2016 at 11:41 PM, Tom Lane wrote:
> =?UTF-8?Q?Filip_Rembia=C5=82kowski?=
> writes:
> > A table has a trigger.
> > The trigger sends a NOTIFY.
> > Test with COPY FROM shows non-linear correlation between number of
> inserted
> >
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