Re: Risk of set system wise statement_timeout

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alex Lai <mlai(at)sesda3(dot)com>
Cc: postgres general support <pgsql-general(at)postgresql(dot)org>
Subject: Re: Risk of set system wise statement_timeout
Date: 2013-09-13 06:53:57
Message-ID: 913.1379055237@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alex Lai <mlai(at)sesda3(dot)com> writes:
> I have been reading few posted comment about the risk for autovacuum for
> older postgres liek version 8.
> I am currently running 9.2.4.

autovacuum ignores any system-wide setting of statement_timeout
(and lock_timeout, where applicable) in all versions back to
at least 8.3.

That doesn't make a system-wide setting necessarily a good idea,
but this particular argument against it doesn't hold water.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rémi Cura 2013-09-13 08:42:05 Computing (disjoint) union of range
Previous Message Chris Travers 2013-09-13 00:25:26 Re: Best way to populate nested composite type from JSON`