Seems like a good idea for template1 to contain ANALYZE stats for the

tglsfdc · tglsfdc · commit 5b69f695acb4 · 2002-09-05T19:56:57.000Z
system tables.
diff --git a/src/bin/initdb/initdb.sh b/src/bin/initdb/initdb.sh
@@ -27,7 +27,7 @@
 # Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group
 # Portions Copyright (c) 1994, Regents of the University of California
 #
-# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.172 2002/09/03 22:17:35 tgl Exp $
+# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.173 2002/09/05 19:56:57 tgl Exp $
 #
 #-------------------------------------------------------------------------
 
@@ -1042,6 +1042,7 @@ echo "ok"
 $ECHO_N "vacuuming database template1... "$ECHO_C
 
 "$PGPATH"/postgres $PGSQL_OPT template1 >/dev/null <<EOF
+ANALYZE;
 VACUUM FULL FREEZE;
 EOF
 if [ "$?" -ne 0 ]; then

Original file line number	Diff line number	Diff line change
`@@ -27,7 +27,7 @@`
`27`	`27`	`# Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group`
`28`	`28`	`# Portions Copyright (c) 1994, Regents of the University of California`
`29`	`29`	`#`
`30`		`-# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.172 2002/09/03 22:17:35 tgl Exp $`
	`30`	`+# $Header: /cvsroot/pgsql/src/bin/initdb/Attic/initdb.sh,v 1.173 2002/09/05 19:56:57 tgl Exp $`
`31`	`31`	`#`
`32`	`32`	`#-------------------------------------------------------------------------`
`33`	`33`
`@@ -1042,6 +1042,7 @@ echo "ok"`
`1042`	`1042`	`$ECHO_N "vacuuming database template1... "$ECHO_C`
`1043`	`1043`
`1044`	`1044`	`"$PGPATH"/postgres $PGSQL_OPT template1 >/dev/null <<EOF`
	`1045`	`+ANALYZE;`
`1045`	`1046`	`VACUUM FULL FREEZE;`
`1046`	`1047`	`EOF`
`1047`	`1048`	`if [ "$?" -ne 0 ]; then`