Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 94B982E01B5 for ; Sat, 23 Feb 2008 14:51:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 60387-01-10 for ; Sat, 23 Feb 2008 14:50:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from smtpoutm.mac.com (smtpoutm.mac.com [17.148.16.67]) by postgresql.org (Postfix) with ESMTP id 420802E01D3 for ; Sat, 23 Feb 2008 14:49:05 -0400 (AST) Received: from mac.com (asmtp002-s [10.150.69.65]) by smtpoutm.mac.com (Xserve/smtpout004/MantshX 4.0) with ESMTP id m1NImxPc025454 for ; Sat, 23 Feb 2008 10:48:59 -0800 (PST) Received: from [10.0.1.253] (75-144-26-241-sfba-ca.hfc.comcastbusiness.net [75.144.26.241] (may be forged)) (authenticated bits=0) by mac.com (Xserve/asmtp002/MantshX 4.0) with ESMTP id m1NImvBH016487 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 23 Feb 2008 10:48:58 -0800 (PST) Mime-Version: 1.0 Message-Id: Date: Sat, 23 Feb 2008 10:48:56 -0800 To: pgsql-performance@postgresql.org From: Joel Stevenson Subject: LISTEN / NOTIFY performance in 8.3 Content-Type: text/plain; charset="us-ascii" ; format="flowed" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200802/300 X-Sequence-Number: 28842 Hi, I'm noticing a strange increase in the amount of time it takes to issue a NOTIFY statement. I have an existing app that provides a producer / consumer type of queue and that uses the LISTEN / NOTIFY mechanism to signal the consumers of new items arriving in the queue. The consumers then process these items and issue a notify to signal that they have been processed. In the past issuing these notifications happened very quickly, now on 8.3 I'm seeing all of them taking over 300ms and many of them taking 1500ms or more! The notifications are happening outside of any transactions (which is itself a probable area for performance improvement, I realize) but I'm wondering what might have changed between 8.1 (the version I was using in the past) and 8.3? TIA, Joel