Re: [PERFORM] NOTIFY performance

2012-08-31 Thread Jeff Janes
On Fri, Aug 31, 2012 at 1:22 PM, Tom Lane wrote: > Jeff Janes writes: >> I wonder if should be trying to drop duplicates at all. I think that >> doing that made a lot more sense before payloads existed. > > Perhaps, but we have a lot of history to be backwards-compatible with. > >> The docs said

Re: [PERFORM] NOTIFY performance

2012-08-31 Thread Tom Lane
Jeff Janes writes: > I wonder if should be trying to drop duplicates at all. I think that > doing that made a lot more sense before payloads existed. Perhaps, but we have a lot of history to be backwards-compatible with. > The docs said that the system "can" drop duplicates, so making it no > l

Re: [PERFORM] NOTIFY performance

2012-08-31 Thread Jeff Janes
On Fri, Aug 24, 2012 at 11:46 AM, Artur Zając wrote: > Hello, > > > I would like to create some application using triggers and LISTEN/NOTIFY > framework. I've tested it, and I noticed that performance of NOTIFY > significally decreases with increasing number of distinct NOTIFIES in > transaction.

Re: [PERFORM] NOTIFY performance

2012-08-28 Thread Merlin Moncure
On Fri, Aug 24, 2012 at 4:11 PM, Artur Zając wrote: >>> I would like to create some application using triggers and >>> LISTEN/NOTIFY framework. I've tested it, and I noticed that >>> performance of NOTIFY significally decreases with increasing number of >>> distinct NOTIFIES in transaction. >>> I

Re: [PERFORM] NOTIFY performance

2012-08-24 Thread Artur Zając
>> I would like to create some application using triggers and >> LISTEN/NOTIFY framework. I've tested it, and I noticed that >> performance of NOTIFY significally decreases with increasing number of >> distinct NOTIFIES in transaction. >> I found that function AsyncExistsPendingNotify is respons

Re: [PERFORM] NOTIFY performance

2012-08-24 Thread Merlin Moncure
On Fri, Aug 24, 2012 at 1:46 PM, Artur Zając wrote: > Hello, > > > I would like to create some application using triggers and LISTEN/NOTIFY > framework. I've tested it, and I noticed that performance of NOTIFY > significally decreases with increasing number of distinct NOTIFIES in > transaction. >

[PERFORM] NOTIFY performance

2012-08-24 Thread Artur Zając
Hello, I would like to create some application using triggers and LISTEN/NOTIFY framework. I've tested it, and I noticed that performance of NOTIFY significally decreases with increasing number of distinct NOTIFIES in transaction. I found that function AsyncExistsPendingNotify is responsibe for