From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jason Armstrong <ja(at)riverdrums(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Workqueue performance |
Date: | 2010-05-18 12:38:49 |
Message-ID: | 5161.1274186329@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jason Armstrong <ja(at)riverdrums(dot)com> writes:
> 1. NOTIFY/LISTEN was causing performance to degrade badly over time. I
> have reworked my code to poll the database instead.
FWIW, you need to ensure pg_listener gets vacuumed pretty aggressively
in order to prevent degradation in a high-traffic NOTIFY application.
PG 9.0 will have a completely rewritten LISTEN/NOTIFY implementation
that avoids use of a table and should scale a lot better, as well as not
needing vacuuming support. That doesn't help you right now, but
depending on what your development timescale is, you might want to plan
to go back to LISTEN/NOTIFY later.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Mead | 2010-05-18 13:42:15 | Re: creating a table based on a table in stored in another database |
Previous Message | Craig Ringer | 2010-05-18 11:38:48 | Re: postgreSQL enquiry |