| From: | Alex Lai <mlai(at)sesda3(dot)com> |
|---|---|
| To: | postgres general support <pgsql-general(at)postgresql(dot)org> |
| Subject: | Risk of set system wise statement_timeout |
| Date: | 2013-09-11 20:02:43 |
| Message-ID: | 5230CC63.6030500@sesda3.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)sesda3(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua Burns | 2013-09-11 20:14:30 | Odd behavior in functions w/ anyarray & anyelement |
| Previous Message | David Johnston | 2013-09-11 19:55:34 | Re: PG 9.3 complains about specified more than once ??? Those views worked in PG 9.1 + 9.2 |