Postgres Pro
Downloads
Home   >   mailing lists

BUG #1588: pg_autovacuum sleep parameter overflow - Mailing list pgsql-bugs

From Lionel Bouton
Subject BUG #1588: pg_autovacuum sleep parameter overflow
Date
Msg-id 20050407091430.F37D3F0C69@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      1588
Logged by:          Lionel Bouton
Email address:      lionel-subscription@bouton.name
PostgreSQL version: 8.0.1
Operating system:   Linux 2.6, glibc 2.3.4
Description:        pg_autovacuum sleep parameter overflow
Details:

pg_autovacuum doesn't sleep when the -s parameter is set above 2147
(PostgreSQL then is under constant stress), seems like a 32-bit signed
integer overflow (the time in µs then gets past 2^31-1) somewhere.

This worked with 7.4.6 (at least with -s 3600).

pgsql-bugs by date:

Previous
From: "Michaela"
Date:
Subject: BUG #1590: Comparison Operation with Strings
Next
From: Ezequiel Tolnay
Date:
Subject: Unexpected behaviour of numeric datatype when mixed with,float4, domains and plpgsql variables