=?UTF-8?Q?Filip_Rembia=C5=82kowski?= <filip.rembialkowski@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
