diff options
Diffstat (limited to 'sql-bench')
| -rw-r--r-- | sql-bench/Comments/postgres.benchmark | 1 | ||||
| -rw-r--r-- | sql-bench/server-cfg.sh | 2 |
2 files changed, 3 insertions, 0 deletions
diff --git a/sql-bench/Comments/postgres.benchmark b/sql-bench/Comments/postgres.benchmark index 6fadf20755e..b25a9931f9e 100644 --- a/sql-bench/Comments/postgres.benchmark +++ b/sql-bench/Comments/postgres.benchmark @@ -84,6 +84,7 @@ run-all-tests --comment="Intel Xeon, 2x550 Mhz, 512M, pg started with -o -F" --u # the database between each major update of the tables: # vacuum table # or +# vacuum analyze # vacuum # The time for vacuum() is accounted for in the book-keeping() column, not diff --git a/sql-bench/server-cfg.sh b/sql-bench/server-cfg.sh index 86b891d8856..a8d992bfdce 100644 --- a/sql-bench/server-cfg.sh +++ b/sql-bench/server-cfg.sh @@ -811,6 +811,7 @@ sub vacuum { foreach $table (@tables) { + $dbh->do("vacuum analyze $table") || die "Got error: $DBI::errstr when executing 'vacuum analyze $table'\n"; $dbh->do("vacuum $table") || die "Got error: $DBI::errstr when executing 'vacuum'\n"; } } @@ -818,6 +819,7 @@ sub vacuum { # $dbh->do("vacuum pg_attributes") || die "Got error: $DBI::errstr when executing 'vacuum'\n"; # $dbh->do("vacuum pg_index") || die "Got error: $DBI::errstr when executing 'vacuum'\n"; + $dbh->do("vacuum analyze") || die "Got error: $DBI::errstr when executing 'vacuum analyze'\n"; $dbh->do("vacuum") || die "Got error: $DBI::errstr when executing 'vacuum'\n"; } $end_time=new Benchmark; |