Joe Conway wrote:
> Bruce Momjian wrote:
> > Uh, I thought you were changing connection_timeout, which is libpq and
> > not a GUC parameter
>
> Yup, you're right -- I got myself confused. Sorry.
>
> > not statement_timeout. Do we want sub-second
> > timeout values? Not sure.
> >
>
> I found it surprising that the statement_timeout was not in units of seconds,
> but that's only because I read the docs after I tried it instead of before. I
> can't think of a reason to have sub-second values, but it's probably not worth
> changing it at this point.
Most queries are sub-second in duration so it seemed logical to keep it
the same as deadlock_timeout. I can see someone setting a 1/2 second
delay for queries.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073