Re: Using NOTIFY... Slow Client Querys

From: Joe Lester <joe_lester(at)sweetwater(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Using NOTIFY... Slow Client Querys
Date: 2004-02-17 13:17:15
Message-ID: 9AE3AF76-614B-11D8-AFDF-000A95A58EA0@sweetwater.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes, my client receives the notification and then it immediately
executes a query that hangs for a while.

On Feb 15, 2004, at 12:07 PM, Tom Lane wrote:
> Hmm. Are you certain that the clients have received the NOTIFY?
> Perhaps the bottleneck is in delivering the NOTIFY messages, not in
> executing the subsequent query.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Lester 2004-02-17 13:21:33 Re: Using NOTIFY... Slow Client Querys
Previous Message P.J. "Josh" Rovero 2004-02-17 12:42:38 Re: Reuse of Subselects