postgres.benchmark
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:3k
- # This file describes how to run MySQL benchmark suite with PostgreSQL
- #
- # WARNING:
- #
- # 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
- # '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.
- #
- # WARNING
- # The test was run on a Intel Xeon 2x 550 Mzh machine with 1G memory,
- # 9G hard disk. The OS is Suse 7.1, with Linux 2.4.2 compiled with SMP
- # support
- # Both the perl client and the database server is run
- # on the same machine. No other cpu intensive process was used during
- # the benchmark.
- #
- # During the test we run PostgreSQL with -o -F, not async mode (not ACID safe)
- # because when we started postmaster without -o -F, PostgreSQL log files
- # filled up a 9G disk until postmaster crashed.
- # We did however notice that with -o -F, PostgreSQL was a magnitude slower
- # than when not using -o -F.
- #
- # First, install postgresql-7.1.2.tar.gz
- # Adding the following lines to your ~/.bash_profile or
- # corresponding file. If you are using csh, use 磗etenv