From: | "James" <im-james(at)hotmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2569: statement_timeout bug on Windows |
Date: | 2006-08-09 06:08:34 |
Message-ID: | 200608090608.k7968YPV061809@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers pgsql-patches |
The following bug has been logged online:
Bug reference: 2569
Logged by: James
Email address: im-james(at)hotmail(dot)com
PostgreSQL version: 8.1.4
Operating system: Windows 200 Pro SP4
Description: statement_timeout bug on Windows
Details:
I'm using the latest version of postgresql (8.1.4) for Windows and I have a
problem with 'statement_timeout'.
Normally statement_timeout should "Abort any statement that takes over the
specified number of milliseconds". However on my pc, instead of milliseconds
it is tenth of seconds. For example: statement_timeout=30 actually means
'wait 3 seconds and abort' instead of wait 30 milliseconds.
I've tested this on the same version of postgresql on Linux and it works
correctly, as stated on the docs.
What do I do to find get this strange result? I do this.
set statement_timeout=30
show statement_timeout
VACUUM ANALYSE
The last statement is aborted after 3 seconds.
set statement_timeout=6
show statement_timeout
VACUUM ANALYSE
The last statement is aborted after 600 milliseconds.
Is this a bug (as I think) or could it be a misconfiguration of my OS, or of
postgresql?
From | Date | Subject | |
---|---|---|---|
Next Message | Franz.Rasper | 2006-08-09 08:10:07 | corruption since 7.4.13 update ? |
Previous Message | tomas | 2006-08-09 05:31:07 | Re: BUG #2565: pg tool doesn't detect window size changes |
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Schiltknecht | 2006-08-09 07:33:35 | Re: standard interfaces for replication providers |
Previous Message | Andrzej B.J.Schulz | 2006-08-09 05:23:25 | unsubscribe |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2006-08-09 11:48:08 | Re: [HACKERS] Restartable Recovery |
Previous Message | Bruce Momjian | 2006-08-09 03:09:59 | Re: Adjustment of compile of ms-vc8 |