From 18a5b4b059d0ee4325fc638db0ce35c1b501ff8a Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Wed, 21 Feb 2007 22:47:45 +0000 Subject: [PATCH] Update new optional VACUUM FULL hint for translations, per Alvaro. --- src/backend/commands/vacuumlazy.c | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c index 53186ebb86..0629991f11 100644 --- a/src/backend/commands/vacuumlazy.c +++ b/src/backend/commands/vacuumlazy.c @@ -185,10 +185,10 @@ lazy_vacuum_rel(Relation onerel, VacuumStmt *vacstmt) (errmsg("relation \"%s.%s\" contains more than \"max_fsm_pages\" pages with useful free space", get_namespace_name(RelationGetNamespace(onerel)), RelationGetRelationName(onerel)), - errhint("Consider%sincreasing the configuration parameter \"max_fsm_pages\".", - /* Only suggest VACUUM FULL if 20% free */ - (vacrelstats->tot_free_pages > vacrelstats->rel_pages * 0.20 - ? " using VACUUM FULL on this relation or ": " ")))); + errhint((vacrelstats->tot_free_pages > vacrelstats->rel_pages * 0.20 ? + /* Only suggest VACUUM FULL if 20% free */ + "Consider using VACUUM FULL on this relation or increasing the configuration parameter \"max_fsm_pages\"." : + "Consider increasing the configuration parameter \"max_fsm_pages\".")))); /* Update statistics in pg_class */ vac_update_relstats(RelationGetRelid(onerel), -- 2.39.5