Skip site navigation (1) Skip section navigation (2)

BUG #1588: pg_autovacuum sleep parameter overflow

From: "Lionel Bouton" <lionel-subscription(at)bouton(dot)name>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1588: pg_autovacuum sleep parameter overflow
Date: 2005-04-07 09:14:30
Message-ID: 20050407091430.F37D3F0C69@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
The following bug has been logged online:

Bug reference:      1588
Logged by:          Lionel Bouton
Email address:      lionel-subscription(at)bouton(dot)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).

Responses

pgsql-bugs by date

Next:From: Ezequiel TolnayDate: 2005-04-07 09:20:25
Subject: Unexpected behaviour of numeric datatype when mixed with,float4, domains and plpgsql variables
Previous:From: Ezequiel TolnayDate: 2005-04-07 09:06:53
Subject: BUG #1587: Unexpected behaviour of numeric datatype when mixed with float4, domains and plpgsql variables

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-04-07 19:17:26
Subject: Re: [GENERAL] A way to let Vacuum warn if FSM settings are
Previous:From: Neil ConwayDate: 2005-04-07 07:56:41
Subject: fork_process() for pgstat

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group