Skip site navigation (1) Skip section navigation (2)

8rc2 & BLCKSZ

From: Pailloncy Jean-Gerard <jg(at)rilk(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: 8rc2 & BLCKSZ
Date: 2004-12-22 16:31:50
Message-ID: FB7893AB-5436-11D9-9A44-000A95DE2550@rilk.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

A small test with 8rc2 and BLCKSZ of 8k and 32k.
It seems there is a 10% increase in the number of transactions by 
second.
Does someone plan to carefully test the impact of BLCKSZ ?

Cordialement,
Jean-GĂ©rard Pailloncy

with 8k:
 > /test/bin/pgbench -c 10 -t 300 test
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 300
number of transactions actually processed: 3000/3000
...
tps = 26.662146 (excluding connections establishing)
tps = 23.742071 (excluding connections establishing)
tps = 28.323828 (excluding connections establishing)
tps = 27.944931 (excluding connections establishing)
tps = 25.898393 (excluding connections establishing)
tps = 26.727316 (excluding connections establishing)
tps = 27.499692 (excluding connections establishing)
tps = 25.430853 (excluding connections establishing)

with 32k:
 > /test/bin/pgbench -c 10 -t 300 test
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 300
number of transactions actually processed: 3000/3000
...
tps = 28.609049 (excluding connections establishing)
tps = 29.978503 (excluding connections establishing)
tps = 30.502606 (excluding connections establishing)
tps = 33.406386 (excluding connections establishing)
tps = 30.422134 (excluding connections establishing)
tps = 26.878762 (excluding connections establishing)
tps = 31.461116 (excluding connections establishing)


Responses

pgsql-performance by date

Next:From: Litao WuDate: 2004-12-22 20:09:04
Subject: Why so much time difference with a same query/plan?
Previous:From: Stacy WhiteDate: 2004-12-22 01:41:39
Subject: Re: Partitioned table performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group