Since I’m doing some tests, and I should be listing hardware that I used (so results will be in any way comparable with anything), I decided to describe test hardware, in here, in more details.

Below is configuration of the machine, with (potentially) updates in future.

State as on 2010-10-28:

  • Hardware:
  • Software:
    • OS: Linux 2.6.35 (2.6.35-22-generic)
    • Distribution: Kubuntu maverick (10.10)
    • PostgreSQL: PostgreSQL 9.0.1 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Ubuntu/Linaro 4.4.4-14ubuntu5) 4.4.5, 64-bit

PostgreSQL is compiled by hand, using method described previously.

When doing bonnie++ tests on the disk, I got following numbers:

Version 1.96 ------Sequential Output------ --Sequential Input- --Random-
Concurrency 1 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
ulek1 10000M 48923 9 25969 4 66781 6 159.1 5
Latency 3417ms 155ms 145ms 185ms
 
Version 1.96 ------Sequential Output------ --Sequential Input- --Random-
Concurrency 5 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
ulek1 10000M 49537 9 26168 4 66825 6 162.6 5
Latency 3848ms 186ms 120ms 385ms
 
Version 1.96 ------Sequential Output------ --Sequential Input- --Random-
Concurrency 10 -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
ulek1 10000M 49498 9 25510 4 66933 6 160.2 5
Latency 3298ms 521ms 73773us 227ms