RE: Timeout parameters - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject RE: Timeout parameters
Date
Msg-id 0A3221C70F24FB45833433255569204D1FBC7A94@G01JPEXMBYT05
Whole thread Raw
In response to Re: Timeout parameters  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
From: Robert Haas [mailto:robertmhaas@gmail.com]
> One other thing -- I looked a bit into the pgsql-jdbc implementation
> of a similarly-named option, and it does seem to match what you are
> proposing here.  I wonder what user experiences with that option have
> been like.

One case I faintly recall is that some SQL execution got stuck in NFS access in the server, and statement_timeout
didn'twork (probably due to inability to cancel NFS read/write operations).  The user chose to use PgJDBC's
socketTimeout. I'm not sure whether this use case is fundamental, because I wonder if NFS mount options could have been
thesolution.
 


Regards
Takayuki Tsunakawa





pgsql-hackers by date:

Previous
From: Shawn Debnath
Date:
Subject: Re: Introduce timeout capability for ConditionVariableSleep
Next
From: "Imai, Yoshikazu"
Date:
Subject: RE: speeding up planning with partitions