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

Re: [PERFORM] bad COPY performance with NOTIFY in a trigger

2016-02-05 Thread Filip Rembiałkowski
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

Re: [PERFORM] View containing a recursive function

2016-02-05 Thread Mathieu De Zutter
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

Re: [PERFORM] bad COPY performance with NOTIFY in a trigger

2016-02-05 Thread Harald Fuchs
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

Re: [PERFORM] bad COPY performance with NOTIFY in a trigger

2016-02-05 Thread Merlin Moncure
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

Re: [PERFORM] bad COPY performance with NOTIFY in a trigger

2016-02-05 Thread Filip Rembiałkowski
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 > >

[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