The FREEZ option is deprecated. See
http://www.postgresql.org/docs/8.3/interactive/sql-vacuum.html
you should use vacuum_freeze_min_age instead. On other side it breaks
vacuumdb backward compatibility which we did not declare, but it could
be fine.
Zdenek
Bruce Momjian píše v út 17.
Zdenek Kotala wrote:
The FREEZ option is deprecated. See
http://www.postgresql.org/docs/8.3/interactive/sql-vacuum.html
I mentioned PGOPTIONS as a suggestion when I posted but on one said that
was a good idea; they just wanted to know why I needed this
functionality.
you should use
Bruce Momjian píše v čt 19. 02. 2009 v 08:08 -0500:
you should use vacuum_freeze_min_age instead. On other side it
breaks
vacuumdb backward compatibility which we did not declare, but it
could
be fine.
How does adding a flag break backward compatibiity?
I meant that
Zdenek Kotala wrote:
Bruce Momjian p??e v ?t 19. 02. 2009 v 08:08 -0500:
you should use vacuum_freeze_min_age instead. On other side it
breaks
vacuumdb backward compatibility which we did not declare, but it
could
be fine.
How does adding a flag break backward compatibiity?
One more question I have though is:
How do you make sure noone (e.g. autovacuum analyze)
unfreezes tuples after the vacuum freeze ?
I will start a new thread to answer this question, but the short answer
is that the freeze only needs to happen in a fresh initdb database, and
once clog
Zeugswetter Andreas OSB sIT andreas.zeugswet...@s-itsolutions.at writes:
I am still answering here because my question was related to upgrade.
I think you need to turn off autovacuum before freezing to avoid a later
analyze
that unfreezes pg_class (or the stats table).
vacuum analyze doesn't
Tom Lane wrote:
Zeugswetter Andreas OSB sIT andreas.zeugswet...@s-itsolutions.at writes:
I am still answering here because my question was related to upgrade.
I think you need to turn off autovacuum before freezing to avoid a later
analyze
that unfreezes pg_class (or the stats table).
Bruce Momjian br...@momjian.us writes:
Tom Lane wrote:
vacuum analyze doesn't unfreeze pg_class. It could create unfrozen
tuples in pg_statistic, perhaps, but we could easily fix that by
truncating pg_statistic afterwards (its not like there will be useful
data there...)
I have added
Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Tom Lane wrote:
vacuum analyze doesn't unfreeze pg_class. It could create unfrozen
tuples in pg_statistic, perhaps, but we could easily fix that by
truncating pg_statistic afterwards (its not like there will be useful
data
Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
Tom Lane wrote:
vacuum analyze doesn't unfreeze pg_class. It could create unfrozen
tuples in pg_statistic, perhaps, but we could easily fix that by
truncating pg_statistic afterwards (its not like there
I would like to add a --freeze parameter to vacuumdb for use by the
binary upgrade utility, and for symmetry with the existing VACUUM
options; patch attached.
Exactly what do you think the upgrade utility is going to do with it?
Surely not a database-wide VACUUM FREEZE, if we are
On Tue, 2009-02-17 at 18:52 -0500, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
I would like to add a --freeze parameter to vacuumdb for use by the
binary upgrade utility, and for symmetry with the existing VACUUM
options; patch attached.
Exactly
Bruce Momjian wrote:
I would like to add a --freeze parameter to vacuumdb for use by the
binary upgrade utility, and for symmetry with the existing VACUUM
options; patch attached.
I could also accomplish with with PGOPTIONs but this seem like a cleaner
solution.
Applied.
--
Bruce
Zeugswetter Andreas OSB sIT wrote:
I would like to add a --freeze parameter to vacuumdb for use by the
binary upgrade utility, and for symmetry with the existing VACUUM
options; patch attached.
Exactly what do you think the upgrade utility is going to do with it?
Surely
I would like to add a --freeze parameter to vacuumdb for use by the
binary upgrade utility, and for symmetry with the existing VACUUM
options; patch attached.
I could also accomplish with with PGOPTIONs but this seem like a cleaner
solution.
--
Bruce Momjian br...@momjian.us
Bruce Momjian br...@momjian.us writes:
I would like to add a --freeze parameter to vacuumdb for use by the
binary upgrade utility, and for symmetry with the existing VACUUM
options; patch attached.
Exactly what do you think the upgrade utility is going to do with it?
Surely not a
Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
I would like to add a --freeze parameter to vacuumdb for use by the
binary upgrade utility, and for symmetry with the existing VACUUM
options; patch attached.
Exactly what do you think the upgrade utility is going to do with it?
17 matches
Mail list logo