Re: PQexec and timeouts

Have you seen 'statement_timeout" SET parameter in 7.3?

---------------------------------------------------------------------------

Medi Montaseri wrote:
> Is there any configuration parameter (run time or compile time) that would
> allow me to timeout from a query.....
>
> ie, say I make a query (select or delete or whatever) against the
> backend which
> is using some disk off of a networked storage (NAS, SAN, etc)...
>
> I need to timeout if the resource (disk or the network) is wedged...
>
> If not, then what if I implement it using
> PQsendQuery()
> select on the connection socket with some timeout
> if you haven't gotton your answer, abort the query...
>
> What is the best way to abort the query...I know of
>
> PQfinish() # too expensive, it closes the TCP connection
> PQreset() # not sure but almost as expensive as PQfinish()
> PQrequestCancel() # this sounds good...
>
> Thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073