Postgres Pro
Downloads
Home   >   mailing lists

Risk of set system wise statement_timeout - Mailing list pgsql-general

From Alex Lai
Subject Risk of set system wise statement_timeout
Date
Msg-id 5230CC63.6030500@sesda3.com
Whole thread Raw
Responses Re: Risk of set system wise statement_timeout  (Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>)
Re: Risk of set system wise statement_timeout  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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.  We have a need to terminate any query
running longer than 2 hours.  Most of our query should finish within 15
minutes.  We don't have very large amount of changes in the system and
we run autovacuum daily.  Running the larger table for autovacuum should
be fast.  Under my situation, setting statement_timeout = 7200000 which
is 2 hours seems very low risk trigger fail to autovacuum.  Any one have
any idea not to do it or any workaround to decrease the risk of fail
autovacuum.

--
Best regards,


Alex Lai
OMI SIPS DBA ADNET Systems , Inc.
mlai@sesda3.com

pgsql-general by date:

Previous
From: Joshua Burns
Date:
Subject: Odd behavior in functions w/ anyarray & anyelement
Next
From: Gregory Haase
Date:
Subject: ZFS snapshots - to use pg_start_backup() and pg_stop_backup() or no?