BUG #2569: statement_timeout bug on Windows

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?

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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