Re: bad COPY performance with NOTIFY in a trigger

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: bad COPY performance with NOTIFY in a trigger
Дата
Msg-id 5721.1454625673@sss.pgh.pa.us
обсуждение исходный текст
Ответ на bad COPY performance with NOTIFY in a trigger  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
Ответы Re: bad COPY performance with NOTIFY in a trigger  (Filip Rembiałkowski <filip.rembialkowski@gmail.com>)
Список pgsql-performance
=?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 по дате отправления:

Предыдущее
От: Filip Rembiałkowski
Дата:
Сообщение: bad COPY performance with NOTIFY in a trigger
Следующее
От: Harald Fuchs
Дата:
Сообщение: Re: bad COPY performance with NOTIFY in a trigger