From: | andy rost <Andy(dot)Rost(at)noaa(dot)gov> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SET statement_timeout |
Date: | 2006-12-07 14:49:45 |
Message-ID: | 45782A09.1090002@noaa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We run VACUUM ANALYZE as a cron job on PostgreSQL v8.1.3 on an Opteron
box running FreeBSD 6.0-RELEASE #10. We set statement_timeout to 7200000
in postgresql.conf. Since this task often takes longer than two hours we
encounter the following messages in our log files:
2006-11-30 00:03:31 CST ERROR: canceling statement due to statement timeout
2006-11-30 00:03:31 CST STATEMENT: VACUUM ANALYZE VERBOSE;
No big deal. We simply modified the cron job to:
set statement_timeout=0; VACUUM ANALYZE VERBOSE;
Should work, right?
Now we get the following entries in our log files:
2006-11-30 00:03:31 CST ERROR: canceling statement due to statement timeout
2006-11-30 00:03:31 CST STATEMENT: set statement_timeout=0; VACUUM
ANALYZE VERBOSE;
I imagine that I have a silly little mistake going on but I just can't
see it. Any ideas?
Thanks ...
--
--------------------------------------------------------------------------------
Andrew Rost
National Operational Hydrologic Remote Sensing Center (NOHRSC)
National Weather Service, NOAA
1735 Lake Dr. West, Chanhassen, MN 55317-8582
Voice: (952)361-6610 x 234
Fax: (952)361-6634
andy(dot)rost(at)noaa(dot)gov
http://www.nohrsc.noaa.gov
--------------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | andy rost | 2006-12-07 14:54:22 | pg_controldata output documentation |
Previous Message | DANTE Alexandra | 2006-12-07 14:47:42 | PostgreSQL 8.2 on IA-64 : 2 regression tests FAILED |