what is maximum allowed value of autovacuum_freeze_max_age

[Radovan Jablonovsky]

Hello,

In documentation
http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html is this
information about autovacuum_freeze_max_age: "if autovacuum_freeze_max_age is
set to its maximum allowed value of a little less than two billion". What
is exact maximum allowed value of autovacuum_freeze_max_age?

Sincerely,
Radovan Jablonovsky

[Kevin Grittner]

Post by Radovan Jablonovsky
In documentation
http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html
is this information about autovacuum_freeze_max_age: "if
autovacuum_freeze_max_age is set to its maximum allowed value of a
little less than two billion". What is exact maximum allowed value
of autovacuum_freeze_max_age?

test=# select name, setting, min_val, max_val
test-# from pg_settings where name = 'autovacuum_freeze_max_age';
name | setting | min_val | max_val
---------------------------+-----------+-----------+------------
autovacuum_freeze_max_age | 200000000 | 100000000 | 2000000000
(1 row)

Perhaps we should drop "a little less than" from the docs.

-Kevin

[Bruce Momjian]

Post by Kevin Grittner

Post by Radovan Jablonovsky
In documentation
http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html
is this information about autovacuum_freeze_max_age: "if
autovacuum_freeze_max_age is set to its maximum allowed value of a
little less than two billion". What is exact maximum allowed value
of autovacuum_freeze_max_age?

test=# select name, setting, min_val, max_val
test-# from pg_settings where name = 'autovacuum_freeze_max_age';
name | setting | min_val | max_val
---------------------------+-----------+-----------+------------
autovacuum_freeze_max_age | 200000000 | 100000000 | 2000000000
(1 row)
Perhaps we should drop "a little less than" from the docs.

Agreed. My guess it they were really talking about the 2-billion that
is a power of 2, but I think just saying 2 billlion is better.
--
Bruce Momjian <***@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

[Kevin Grittner]

Post by Bruce Momjian

Post by Kevin Grittner

Post by Radovan Jablonovsky
In documentation
http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html
is this information about autovacuum_freeze_max_age: "if
autovacuum_freeze_max_age is set to its maximum allowed value of
a little less than two billion". What is exact maximum allowed
value of autovacuum_freeze_max_age?

Perhaps we should drop "a little less than" from the docs.

Agreed.

Hearing no objection, done. Back-patched to 8.3 on the basis that
this was a bug in the documentation, and one which has actually
caused end-user confusion.

-Kevin