The following bug has been logged online:
Bug reference: 2569
Logged by: James
Email address: im-james@hotmail.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?