Here it is,

a small tweak to enable display in the log file
of database name before table name
when VACUUMing or ANALYZing a table.


-- Cosimo
--- postgresql-8.0.1/contrib/pg_autovacuum/pg_autovacuum.c.orig	Fri Mar 18 12:03:54 2005
+++ postgresql-8.0.1/contrib/pg_autovacuum/pg_autovacuum.c	Fri Mar 18 12:04:03 2005
@@ -1049,9 +1049,9 @@
 	 */
 	if ((tbl->relisshared > 0 && strcmp("template1", dbi->dbname) != 0) ||
 		(operation == ANALYZE_ONLY))
-		snprintf(buf, sizeof(buf), "ANALYZE %s", tbl->table_name);
+		snprintf(buf, sizeof(buf), "ANALYZE %s.%s", dbi->dbname, tbl->table_name);
 	else if (operation == VACUUM_ANALYZE)
-		snprintf(buf, sizeof(buf), "VACUUM ANALYZE %s", tbl->table_name);
+		snprintf(buf, sizeof(buf), "VACUUM ANALYZE %s.%s", dbi->dbname, tbl->table_name);
 	else
 		return;
 
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to