Change vacuum lazy "compacting" warning message to:

bmomjian · bmomjian · commit c29a0bd52c63 · 2007-02-04T03:10:55.000Z
errhint("Consider using VACUUM FULL on this relation or increasing the configuration parameter \"max_fsm_pages\".")));
diff --git a/src/backend/commands/vacuumlazy.c b/src/backend/commands/vacuumlazy.c
@@ -36,7 +36,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/commands/vacuumlazy.c,v 1.82 2007/01/05 22:19:27 momjian Exp $
+ *	  $PostgreSQL: pgsql/src/backend/commands/vacuumlazy.c,v 1.83 2007/02/04 03:10:55 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -513,7 +513,7 @@ lazy_scan_heap(Relation onerel, LVRelStats *vacrelstats,
 				(errmsg("relation \"%s.%s\" contains more than \"max_fsm_pages\" pages with useful free space",
 						get_namespace_name(RelationGetNamespace(onerel)),
 						relname),
-				 errhint("Consider compacting this relation or increasing the configuration parameter \"max_fsm_pages\".")));
+				 errhint("Consider using VACUUM FULL on this relation or increasing the configuration parameter \"max_fsm_pages\".")));
 }
 
 

Original file line number	Diff line number	Diff line change
`@@ -36,7 +36,7 @@`
`36`	`36`	`*`
`37`	`37`	`*`
`38`	`38`	`* IDENTIFICATION`
`39`		`- * $PostgreSQL: pgsql/src/backend/commands/vacuumlazy.c,v 1.82 2007/01/05 22:19:27 momjian Exp $`
	`39`	`+ * $PostgreSQL: pgsql/src/backend/commands/vacuumlazy.c,v 1.83 2007/02/04 03:10:55 momjian Exp $`
`40`	`40`	`*`
`41`	`41`	`*-------------------------------------------------------------------------`
`42`	`42`	`*/`
`@@ -513,7 +513,7 @@ lazy_scan_heap(Relation onerel, LVRelStats *vacrelstats,`
`513`	`513`	`(errmsg("relation \"%s.%s\" contains more than \"max_fsm_pages\" pages with useful free space",`
`514`	`514`	`get_namespace_name(RelationGetNamespace(onerel)),`
`515`	`515`	`relname),`
`516`		`- errhint("Consider compacting this relation or increasing the configuration parameter \"max_fsm_pages\".")));`
	`516`	`+ errhint("Consider using VACUUM FULL on this relation or increasing the configuration parameter \"max_fsm_pages\".")));`
`517`	`517`	`}`
`518`	`518`
`519`	`519`