📄 postgres.benchmark
字号:
# 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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -