From: | Joe Lester <joe_lester(at)sweetwater(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Using NOTIFY... Slow Client Querys |
Date: | 2004-02-13 18:12:59 |
Message-ID: | 4126289A-5E50-11D8-90A2-000A95A58EA0@sweetwater.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm using PostgreSQL 7.4.1. I have 140 clients connected on average
using libpq. When one client sends "NOTIFY timeclock;" to the server
all 140 clients are listening for it.
After receiving a notification from libpq (PQnotifies), each client
proceeds to execute a query for the last five records in the timeclock
table.
SELECT * FROM timeclock ORDER BY touched DESC LIMIT 5;
It varies, but it's often the case that clients wait up to 3 minutes
before the results come back. This seems like a really long time for a
query that I would think would go quickly. In fact, I can execute the
same query from a third party client and it runs fine, even while my
own client is still waiting for results.
Any ideas? It seems to be related to NOTIFY/LISTEN. Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Maldonado | 2004-02-13 18:19:03 | Index storage question... |
Previous Message | Andrew Sullivan | 2004-02-13 17:47:17 | Re: Quad Xeon vs. Dual Itanium |