Skip site navigation (1) Skip section navigation (2)

Statement Timeout Message Incorrect

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Steven FlattDate: 2008-01-23 20:26:41
Subject: BUG #3898: Postgres autovacuum not respecting pg_autovacuum.enabled = false
Previous:From: Tom LaneDate: 2008-01-23 17:04:11
Subject: Re: 8.2 and 8.3 postgresql.conf oddity

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group