Re: RE: Re: [ADMIN] v7.1b4 bad performance

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: Vadim Mikheev <vadim4o(at)email(dot)com>, Hannu Krosing <hannu(at)tm(dot)ee>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: RE: Re: [ADMIN] v7.1b4 bad performance
Date: 2001-02-26 02:01:17
Message-ID: 3.0.5.32.20010226100117.00a3a100@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Oops I screwed up again. :)

I was actually right the first time my postgresql 7.0.3 was running with
fsync off. Due to my weird results I searched more thoroughly and found my
7.0.3's pg_options had a nofsync=1.

So 7.0.3 is twice as fast only with fsync off.

7.1beta4 snapshot - fsync.

./pgbench -i pgbench -s 5
./pgbench -c 5 -t 500 pgbench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 5
number of clients: 5
number of transactions per client: 500
number of transactions actually processed: 2500/2500
tps = 22.435799(including connections establishing)
tps = 22.453842(excluding connections establishing)

7.0.3 no fsync
./pgbench -i pgbench -s 5
./pgbench -c 5 -t 500 pgbench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 5
number of clients: 5
number of transactions per client: 500
number of transactions actually processed: 2500/2500
tps = 52.971997(including connections establishing)
tps = 53.044280(excluding connections establishing)

7.0.3 fsync
./pgbench -c 5 -t 500 pgbench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 5
number of clients: 5
number of transactions per client: 500
number of transactions actually processed: 2500/2500
tps = 7.366986(including connections establishing)
tps = 7.368807(excluding connections establishing)

Cheerio,
Link.

Browse pgsql-hackers by date

  From Date Subject
Next Message Vince Vielhaber 2001-02-26 03:33:45 Re: Monitor status
Previous Message Bruce Momjian 2001-02-26 02:00:41 [PATCHES] A patch for xlog.c