Обсуждение: BUG #1588: pg_autovacuum sleep parameter overflow

Поиск
Список
Период
Сортировка

BUG #1588: pg_autovacuum sleep parameter overflow

От
"Lionel Bouton"
Дата:
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).