diff options
author | monty@hundin.mysql.fi <> | 2001-06-05 04:05:33 +0300 |
---|---|---|
committer | monty@hundin.mysql.fi <> | 2001-06-05 04:05:33 +0300 |
commit | 704c03ca572d0f6c98a125fce37771efd09f2b81 (patch) | |
tree | b952b185420f1578799b95526a1c2eeb16a583b9 /sql-bench/Comments | |
parent | 0fd7d236f33ad579dd031a678721e3c7affec6fe (diff) | |
download | mariadb-git-704c03ca572d0f6c98a125fce37771efd09f2b81.tar.gz |
Updated benchmarks and crash-me for postgreSQL 7.1.1
Fixed option for symlinks
Diffstat (limited to 'sql-bench/Comments')
-rw-r--r-- | sql-bench/Comments/postgres.benchmark | 19 |
1 files changed, 16 insertions, 3 deletions
diff --git a/sql-bench/Comments/postgres.benchmark b/sql-bench/Comments/postgres.benchmark index cce9a8f05fe..4b417b8f97e 100644 --- a/sql-bench/Comments/postgres.benchmark +++ b/sql-bench/Comments/postgres.benchmark @@ -5,9 +5,16 @@ # Don't run the --fast test on a PostgreSQL 7.1.1 database on # which you have any critical data; During one of our test runs # PostgreSQL got a corrupted database and all data was destroyed! -# (When we tried to restart postmaster, It died with a +# When we tried to restart postmaster, It died with a # 'no such file or directory' error and never recovered from that! # +# Another time vacuum() filled our system disk with had 6G free +# while vaccuming a table of 60 M. +# +# We have sent a mail about this to the PostgreSQL mailing list, so +# the PostgreSQL developers should be aware of these problems and should +# hopefully fix this soon. +# # WARNING # The test was run on a Intel Xeon 2x 550 Mzh machine with 1G memory, @@ -73,8 +80,14 @@ make install run-all-tests --comment="Intel Xeon, 2x550 Mhz, 512M, pg started with -o -F" --user=postgres --server=pg --cmp=mysql -# and a test where we do a vacuum() after each update. -# (The time for vacuum() is counted in the book-keeping() column) +# When running with --fast we run the following vacuum commands on +# the database between each major update of the tables: +# vacuum table +# or +# vacuum + +# The time for vacuum() is accounted for in the book-keeping() column, not +# in the test that updates the database. run-all-tests --comment="Intel Xeon, 2x550 Mhz, 512M, pg started with -o -F" --user=postgres --server=pg --cmp=mysql --fast |