| From: | Yeb Havinga <yebhavinga(at)gmail(dot)com> |
|---|---|
| To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
| Cc: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Sync Rep v19 |
| Date: | 2011-03-07 13:20:08 |
| Message-ID: | 4D74DB88.9040101@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2011-03-07 01:37, Simon Riggs wrote:
> On Sat, 2011-03-05 at 21:11 +0100, Yeb Havinga wrote:
>
>> I also got a first first> 1000 tps score
> The committed version should be even faster. Would appreciate a retest.
>
pgbench 5 minute test pgbench -c 10 -M prepared -T 300 test
dbsize was -s 50, 1Gbit Ethernet
1 async standby
tps = 2475.285931 (excluding connections establishing)
2 async standbys
tps = 2333.670561 (excluding connections establishing)
1 sync standby
tps = 1277.082753 (excluding connections establishing)
1 sync, 1 async standby
tps = 1273.317386 (excluding connections establishing)
Hard for me to not revert to superlatives right now! :-)
regards,
Yeb Havinga
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2011-03-07 13:30:34 | Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. |
| Previous Message | Jan Urbański | 2011-03-07 13:19:46 | Re: pl/python tracebacks |