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

Re: CommitDelay performance improvement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CommitDelay performance improvement
Date: 2001-02-25 07:03:52
Message-ID: 19976.983084632@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> Don't suppose you could post the original data?

Sure.

			regards, tom lane

commit_delay = 0
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 10.996953(including connections establishing)
tps = 11.051216(excluding connections establishing)
commit_delay = 0
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 17.779923(including connections establishing)
tps = 17.924390(excluding connections establishing)
commit_delay = 0
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 17.289815(including connections establishing)
tps = 17.429343(excluding connections establishing)
commit_delay = 0
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 17.292171(including connections establishing)
tps = 17.432905(excluding connections establishing)
commit_delay = 0
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 17.733478(including connections establishing)
tps = 17.913251(excluding connections establishing)
commit_delay = 0
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 18.325273(including connections establishing)
tps = 18.534556(excluding connections establishing)
commit_delay = 10000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 10.449347(including connections establishing)
tps = 10.500278(excluding connections establishing)
commit_delay = 10000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 17.865721(including connections establishing)
tps = 18.015078(excluding connections establishing)
commit_delay = 10000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 17.980234(including connections establishing)
tps = 18.131986(excluding connections establishing)
commit_delay = 10000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 18.858489(including connections establishing)
tps = 19.027436(excluding connections establishing)
commit_delay = 10000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 19.320221(including connections establishing)
tps = 19.496999(excluding connections establishing)
commit_delay = 10000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 19.440978(including connections establishing)
tps = 19.621221(excluding connections establishing)
commit_delay = 10000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.298701(including connections establishing)
tps = 11.357102(excluding connections establishing)
commit_delay = 10000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 19.722266(including connections establishing)
tps = 19.903373(excluding connections establishing)
commit_delay = 10000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 19.042737(including connections establishing)
tps = 19.214042(excluding connections establishing)
commit_delay = 10000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 19.013869(including connections establishing)
tps = 19.185863(excluding connections establishing)
commit_delay = 10000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.081644(including connections establishing)
tps = 20.273612(excluding connections establishing)
commit_delay = 10000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.379646(including connections establishing)
tps = 20.577183(excluding connections establishing)
commit_delay = 10000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 10.896660(including connections establishing)
tps = 10.951360(excluding connections establishing)
commit_delay = 10000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 19.506836(including connections establishing)
tps = 19.686328(excluding connections establishing)
commit_delay = 10000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 18.801060(including connections establishing)
tps = 18.968530(excluding connections establishing)
commit_delay = 10000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 19.855547(including connections establishing)
tps = 20.044110(excluding connections establishing)
commit_delay = 10000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.557934(including connections establishing)
tps = 20.760724(excluding connections establishing)
commit_delay = 10000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.278060(including connections establishing)
tps = 20.473699(excluding connections establishing)
commit_delay = 10000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.098777(including connections establishing)
tps = 11.155340(excluding connections establishing)
commit_delay = 10000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 18.638060(including connections establishing)
tps = 18.801436(excluding connections establishing)
commit_delay = 10000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 19.815520(including connections establishing)
tps = 20.003053(excluding connections establishing)
commit_delay = 10000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.034017(including connections establishing)
tps = 20.231631(excluding connections establishing)
commit_delay = 10000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.676088(including connections establishing)
tps = 20.879088(excluding connections establishing)
commit_delay = 10000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.692725(including connections establishing)
tps = 20.895842(excluding connections establishing)
commit_delay = 30000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.160902(including connections establishing)
tps = 11.218247(excluding connections establishing)
commit_delay = 30000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 18.831596(including connections establishing)
tps = 19.000649(excluding connections establishing)
commit_delay = 30000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 20.239767(including connections establishing)
tps = 20.434566(excluding connections establishing)
commit_delay = 30000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.686848(including connections establishing)
tps = 20.891519(excluding connections establishing)
commit_delay = 30000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 21.014861(including connections establishing)
tps = 21.224443(excluding connections establishing)
commit_delay = 30000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 21.315164(including connections establishing)
tps = 21.533027(excluding connections establishing)
commit_delay = 30000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.384356(including connections establishing)
tps = 11.444286(excluding connections establishing)
commit_delay = 30000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 18.614866(including connections establishing)
tps = 18.780395(excluding connections establishing)
commit_delay = 30000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 20.462955(including connections establishing)
tps = 20.661262(excluding connections establishing)
commit_delay = 30000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.769457(including connections establishing)
tps = 20.975243(excluding connections establishing)
commit_delay = 30000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 19.280678(including connections establishing)
tps = 19.457795(excluding connections establishing)
commit_delay = 30000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.852166(including connections establishing)
tps = 21.057769(excluding connections establishing)
commit_delay = 30000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.129848(including connections establishing)
tps = 11.188346(excluding connections establishing)
commit_delay = 30000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 19.154248(including connections establishing)
tps = 19.328718(excluding connections establishing)
commit_delay = 30000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 19.487838(including connections establishing)
tps = 19.668323(excluding connections establishing)
commit_delay = 30000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.387741(including connections establishing)
tps = 20.586291(excluding connections establishing)
commit_delay = 30000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 21.187943(including connections establishing)
tps = 21.403037(excluding connections establishing)
commit_delay = 30000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.870339(including connections establishing)
tps = 21.080454(excluding connections establishing)
commit_delay = 30000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.119876(including connections establishing)
tps = 11.177152(excluding connections establishing)
commit_delay = 30000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 18.987202(including connections establishing)
tps = 19.157841(excluding connections establishing)
commit_delay = 30000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 19.771415(including connections establishing)
tps = 19.957555(excluding connections establishing)
commit_delay = 30000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.277710(including connections establishing)
tps = 20.473996(excluding connections establishing)
commit_delay = 30000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.736168(including connections establishing)
tps = 20.942539(excluding connections establishing)
commit_delay = 30000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 18.894930(including connections establishing)
tps = 19.064049(excluding connections establishing)
commit_delay = 50000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.006743(including connections establishing)
tps = 11.062485(excluding connections establishing)
commit_delay = 50000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 18.240024(including connections establishing)
tps = 18.399169(excluding connections establishing)
commit_delay = 50000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 19.817212(including connections establishing)
tps = 20.002657(excluding connections establishing)
commit_delay = 50000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.260368(including connections establishing)
tps = 20.455821(excluding connections establishing)
commit_delay = 50000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.928079(including connections establishing)
tps = 21.135532(excluding connections establishing)
commit_delay = 50000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 21.216875(including connections establishing)
tps = 21.431381(excluding connections establishing)
commit_delay = 50000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.362410(including connections establishing)
tps = 11.421545(excluding connections establishing)
commit_delay = 50000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 18.879526(including connections establishing)
tps = 19.047014(excluding connections establishing)
commit_delay = 50000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 20.100514(including connections establishing)
tps = 20.292700(excluding connections establishing)
commit_delay = 50000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.108420(including connections establishing)
tps = 20.326053(excluding connections establishing)
commit_delay = 50000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.876438(including connections establishing)
tps = 21.083252(excluding connections establishing)
commit_delay = 50000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.929535(including connections establishing)
tps = 21.139167(excluding connections establishing)
commit_delay = 50000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.037506(including connections establishing)
tps = 11.094671(excluding connections establishing)
commit_delay = 50000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 16.197469(including connections establishing)
tps = 16.321687(excluding connections establishing)
commit_delay = 50000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 19.408106(including connections establishing)
tps = 19.586455(excluding connections establishing)
commit_delay = 50000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.628612(including connections establishing)
tps = 20.832682(excluding connections establishing)
commit_delay = 50000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.687795(including connections establishing)
tps = 20.892172(excluding connections establishing)
commit_delay = 50000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 21.072593(including connections establishing)
tps = 21.285268(excluding connections establishing)
commit_delay = 50000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 11.114714(including connections establishing)
tps = 11.172162(excluding connections establishing)
commit_delay = 50000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 19.558748(including connections establishing)
tps = 19.742513(excluding connections establishing)
commit_delay = 50000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 18.631916(including connections establishing)
tps = 18.797678(excluding connections establishing)
commit_delay = 50000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 19.825138(including connections establishing)
tps = 20.012726(excluding connections establishing)
commit_delay = 50000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.088452(including connections establishing)
tps = 20.280854(excluding connections establishing)
commit_delay = 50000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.297366(including connections establishing)
tps = 20.493717(excluding connections establishing)
commit_delay = 100000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 15.439671(including connections establishing)
tps = 15.549962(excluding connections establishing)
commit_delay = 100000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 19.693075(including connections establishing)
tps = 19.876400(excluding connections establishing)
commit_delay = 100000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 18.946142(including connections establishing)
tps = 19.115107(excluding connections establishing)
commit_delay = 100000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 18.454647(including connections establishing)
tps = 18.616867(excluding connections establishing)
commit_delay = 100000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.280877(including connections establishing)
tps = 20.476160(excluding connections establishing)
commit_delay = 100000
commit_siblings = 1
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.500824(including connections establishing)
tps = 20.701014(excluding connections establishing)
commit_delay = 100000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 10.952132(including connections establishing)
tps = 11.006296(excluding connections establishing)
commit_delay = 100000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 17.366365(including connections establishing)
tps = 17.508544(excluding connections establishing)
commit_delay = 100000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 19.543583(including connections establishing)
tps = 19.725347(excluding connections establishing)
commit_delay = 100000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.115157(including connections establishing)
tps = 20.307981(excluding connections establishing)
commit_delay = 100000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 20.223466(including connections establishing)
tps = 20.420063(excluding connections establishing)
commit_delay = 100000
commit_siblings = 5
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.148971(including connections establishing)
tps = 20.341425(excluding connections establishing)
commit_delay = 100000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 10.751800(including connections establishing)
tps = 10.805719(excluding connections establishing)
commit_delay = 100000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 17.248793(including connections establishing)
tps = 17.389532(excluding connections establishing)
commit_delay = 100000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 18.971746(including connections establishing)
tps = 19.141706(excluding connections establishing)
commit_delay = 100000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 20.250238(including connections establishing)
tps = 20.445726(excluding connections establishing)
commit_delay = 100000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 18.616027(including connections establishing)
tps = 18.782432(excluding connections establishing)
commit_delay = 100000
commit_siblings = 10
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.101571(including connections establishing)
tps = 20.293550(excluding connections establishing)
commit_delay = 100000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 1
number of transactions per client: 100
number of transactions actually processed: 100/100
tps = 10.630630(including connections establishing)
tps = 10.682598(excluding connections establishing)
commit_delay = 100000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 10
number of transactions per client: 100
number of transactions actually processed: 1000/1000
tps = 17.308711(including connections establishing)
tps = 17.450166(excluding connections establishing)
commit_delay = 100000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 20
number of transactions per client: 100
number of transactions actually processed: 2000/2000
tps = 18.041733(including connections establishing)
tps = 18.196939(excluding connections establishing)
commit_delay = 100000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 30
number of transactions per client: 100
number of transactions actually processed: 3000/3000
tps = 18.610682(including connections establishing)
tps = 18.775963(excluding connections establishing)
commit_delay = 100000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 40
number of transactions per client: 100
number of transactions actually processed: 4000/4000
tps = 19.522874(including connections establishing)
tps = 19.705095(excluding connections establishing)
commit_delay = 100000
commit_siblings = 20
CHECKPOINT
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 50
number of transactions per client: 100
number of transactions actually processed: 5000/5000
tps = 20.085380(including connections establishing)
tps = 20.277826(excluding connections establishing)

In response to

pgsql-hackers by date

Next:From: Nathan MyersDate: 2001-02-25 08:42:49
Subject: Re: CommitDelay performance improvement
Previous:From: Philip WarnerDate: 2001-02-25 07:01:45
Subject: Re: CommitDelay performance improvement

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