| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ezequiel Tolnay | 2005-04-07 09:20:25 | Unexpected behaviour of numeric datatype when mixed with,float4, domains and plpgsql variables |
| Previous Message | Ezequiel Tolnay | 2005-04-07 09:06:53 | BUG #1587: Unexpected behaviour of numeric datatype when mixed with float4, domains and plpgsql variables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-04-07 19:17:26 | Re: [GENERAL] A way to let Vacuum warn if FSM settings are |
| Previous Message | Neil Conway | 2005-04-07 07:56:41 | fork_process() for pgstat |