Re: Perl DBD and an alarming problem - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: Perl DBD and an alarming problem
Date
Msg-id 20051117232857.GA49910@winnie.fuhr.org
Whole thread Raw
In response to Re: Perl DBD and an alarming problem  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
On Thu, Nov 17, 2005 at 01:04:21PM -0800, Craig A. James wrote:
> When I set statement_timeout in the config file, it just didn't do anything
> - it never timed out (PG 8.0.3).  I finally found in the documentation that
> I can do "set statement_timeout = xxx" from PerlDBI on a per-client basis,
> and that works.

You probably shouldn't set statement_timeout on a global basis
anyway, but did you reload the server after you made the change?
Setting statement_timeout in postgresql.conf and then reloading the
server works here in 8.0.4.

--
Michael Fuhr

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: weird performances problem
Next
From: Guillaume Smet
Date:
Subject: Re: weird performances problem