Re: PQexec and timeouts
| От | Medi Montaseri |
|---|---|
| Тема | Re: PQexec and timeouts |
| Дата | |
| Msg-id | 3DF7EFD8.3020607@intransa.com обсуждение исходный текст |
| Ответ на | Re: PQexec and timeouts (Bruce Momjian <pgman@candle.pha.pa.us>) |
| Список | pgsql-general |
Ahaa....that is good....keep it comming.... Bruce Momjian wrote: >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@postgresql.org so that your >>message can get through to the mailing list cleanly >> >> >> > > >
В списке pgsql-general по дате отправления: