From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | elein <elein(at)varlena(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Statement Timeout Message Incorrect |
Date: | 2008-01-23 20:52:35 |
Message-ID: | 25252.1201121555@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
elein <elein(at)varlena(dot)com> writes:
> 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.
Hmmm ... are you using integer timestamps by any chance?
It looks to me like TimestampTzPlusMilliseconds() would overflow
for such a large timeout.
> The script runs in ~3 hours including the timeout messages.
If I'm doing the math correctly, 1 day would overflow to about
8 minutes in microseconds, so if you're seeing individual statements
time out after more than that then there's something else going on.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | elein | 2008-01-24 00:06:19 | Re: Statement Timeout Message Incorrect |
Previous Message | Steven Flatt | 2008-01-23 20:26:41 | BUG #3898: Postgres autovacuum not respecting pg_autovacuum.enabled = false |