Postgres Pro
Downloads
Home   >   mailing lists

Re: bad COPY performance with NOTIFY in a trigger - Mailing list pgsql-performance

From Tom Lane
Subject Re: bad COPY performance with NOTIFY in a trigger
Date
Msg-id 5721.1454625673@sss.pgh.pa.us
Whole thread Raw
In response to bad COPY performance with NOTIFY in a trigger  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
Responses Re: bad COPY performance with NOTIFY in a trigger
List pgsql-performance
Tree view 
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= <filip.rembialkowski@gmail.com> writes:
> A table has a trigger.
> The trigger sends a NOTIFY.
> Test with COPY FROM shows non-linear correlation between number of inserted
> rows and COPY duration.

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.

            regards, tom lane

pgsql-performance by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: bad COPY performance with NOTIFY in a trigger
Next
From: Harald Fuchs
Date:
Subject: Re: bad COPY performance with NOTIFY in a trigger