| From: | elein <elein(at)varlena(dot)com> | 
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org | 
| Cc: | elein(at)varlena(dot)com | 
| Subject: | Statement Timeout Message Incorrect | 
| Date: | 2008-01-23 19:22:06 | 
| Message-ID: | 20080123192206.GA14970@varlena.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-bugs | 
Running 8.3RC1
I have an sql script where one or more create index statements
raise a statement timeout message. The statement timeout is
set to 1d.
The script runs in ~3 hours including the timeout messages.
The script does this:
BEGIN;
create table temp.xxx ...
insert into temp.xxx ...
COMMIT;
create index one on temp.xxx(col1);
create index one on temp.xxx(col2);
create index one on temp.xxx(col3);
create index one on temp.xxx(col4);
BEGIN;
drop table public.xxx;
alter table temp.xxx set schema public;
COMMIT;
I have sprinkled the script with show statement_timeout
and it always returns 1D.
I suspect either a problem with counting statement time
or another error is using the statement timeout message.
Ideas?
--elein
elein(at)varlena(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steven Flatt | 2008-01-23 20:26:41 | BUG #3898: Postgres autovacuum not respecting pg_autovacuum.enabled = false | 
| Previous Message | Tom Lane | 2008-01-23 17:04:11 | Re: 8.2 and 8.3 postgresql.conf oddity |