Re: [GENERAL] Risk of set system wise statement_timeout

2013-09-12 Thread Tom Lane
Alex Lai 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.

Re: [GENERAL] Risk of set system wise statement_timeout

2013-09-12 Thread Alex Lai
On 09/12/2013 10:09 AM, Giuseppe Broccolo wrote: Il 11/09/2013 22:02, Alex Lai ha scritto: 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. M

Re: [GENERAL] Risk of set system wise statement_timeout

2013-09-12 Thread Giuseppe Broccolo
Il 11/09/2013 22:02, Alex Lai ha scritto: 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.

[GENERAL] Risk of set system wise statement_timeout

2013-09-11 Thread Alex Lai
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 change