Re: lock timeout patch

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp>
Cc: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: lock timeout patch
Date: 2004-06-29 13:37:15
Message-ID: 20040629133715.GB28041@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 29, 2004 at 09:25:27 +0900,
Satoshi Nagayasu <nagayasus(at)nttdata(dot)co(dot)jp> wrote:
>
> But I don't want to wait one or more minutes just for a lock.
> I need to return a message to the user "retry later." or
> something like that. It depends on various applications.

Why not set statement timeout low when you are about to run a query
that you think should return quickly?

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-29 13:43:55 Re: client_min_messages in dumps?
Previous Message Hannu Krosing 2004-06-29 11:40:01 Re: recursive SQL