| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Joel Stevenson <joelstevenson(at)mac(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: LISTEN / NOTIFY performance in 8.3 |
| Date: | 2008-02-23 19:35:35 |
| Message-ID: | 5576.1203795335@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Joel Stevenson <joelstevenson(at)mac(dot)com> writes:
> 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!
That's strange, I would not have thought that listen/notify behavior
would change at all. How are you measuring this delay exactly?
Can you put together a self-contained test case?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Stevenson | 2008-02-24 05:22:29 | Re: LISTEN / NOTIFY performance in 8.3 |
| Previous Message | Joel Stevenson | 2008-02-23 18:48:56 | LISTEN / NOTIFY performance in 8.3 |