Re: NOTIFY and pg_notify performance when deduplicating notifications

2018-11-18 Thread Julien Demoor
On 10/10/2018 19:42, Catalin Iacob wrote: On Tue, Oct 9, 2018 at 2:17 PM wrote: I just caught an error in my patch, it's fixed in the attachment. The 'never' and 'maybe' collapse modes were mixed up in one location. Here's a partial review of this version, did not read the doc part very caref

Re: NOTIFY and pg_notify performance when deduplicating notifications

2018-12-05 Thread Julien Demoor
postgres=# rollback; ROLLBACK Time: 0.864 ms postgres=# postgres=# postgres=# begin; BEGIN Time: 0.126 ms postgres=# select count(*) from (select pg_notify('my_channel', g::text, 'never') from generate_series(1, 20) g) x; count 20 (1 row) Time: 86.477 ms po