Re: pgbench results

2008-03-13 Thread Ivan Voras
On 13/03/2008, Jeff Roberson <[EMAIL PROTECTED]> wrote: > > On Wed, 12 Mar 2008, Ivan Voras wrote: > > > On 12/03/2008, Mark Kirkwood <[EMAIL PROTECTED]> wrote: > > > >> Hmm - somehow read right past the bit where you say you have a 512MB > >> cache - sorry! However, worth checking it is set

Re: pgbench results

2008-03-13 Thread Ivan Voras
Ivan Voras wrote: > On 12/03/2008, Mark Kirkwood <[EMAIL PROTECTED]> wrote: > >> Hmm - somehow read right past the bit where you say you have a 512MB >> cache - sorry! However, worth checking it is set to write-back rather >> than write-through. > > As far as I can see it is set to write-throug

Re: pgbench results

2008-03-12 Thread Jeff Roberson
On Wed, 12 Mar 2008, Ivan Voras wrote: On 12/03/2008, Mark Kirkwood <[EMAIL PROTECTED]> wrote: Hmm - somehow read right past the bit where you say you have a 512MB cache - sorry! However, worth checking it is set to write-back rather than write-through. As far as I can see it is set to wr

Re: pgbench results

2008-03-12 Thread Ivan Voras
On 12/03/2008, Mark Kirkwood <[EMAIL PROTECTED]> wrote: > Hmm - somehow read right past the bit where you say you have a 512MB > cache - sorry! However, worth checking it is set to write-back rather > than write-through. As far as I can see it is set to write-through (though the HP's array conf

Re: pgbench results

2008-03-11 Thread Mark Kirkwood
Mark Kirkwood wrote: Ivan Voras wrote: The thing is - I *do* have a similar setup here: HP DL370 G5, 2x4-core 1.86 GHz, 4 GB RAM, 6 drives in RAID10, 512 MB cache (can pull > 200 MB/s off the array), with all settings like in the posted link except shared_buffer=1900 MB, and I "only" get this:

Re: pgbench results

2008-03-11 Thread Mark Kirkwood
Ivan Voras wrote: The thing is - I *do* have a similar setup here: HP DL370 G5, 2x4-core 1.86 GHz, 4 GB RAM, 6 drives in RAID10, 512 MB cache (can pull > 200 MB/s off the array), with all settings like in the posted link except shared_buffer=1900 MB, and I "only" get this: tps = 2834.026175 (in

Re: pgbench results

2008-03-11 Thread Ivan Voras
http://www.kaltenbrunner.cc/blog/index.php?/archives/21-guid.html alan bryan wrote: > Here's mine for a somewhat similar setup. > FreeBSD 7.0 PostgreSQL 8.3 > 2x Intel Xeon 2.33GHZ quad cores (8 cores total), 8GB > RAM, 250GB RAID 10 (4x WD Raptor 10K drives). > > Non-default settings: > >

Re: pgbench results

2008-03-10 Thread alan bryan
--- Ivan Voras <[EMAIL PROTECTED]> wrote: > Hi, > > Has anyone been able to replicate results from > http://www.kaltenbrunner.cc/blog/index.php?/archives/21-guid.html, > or > get close to the performance described there on > similar hardware (e.g. > thousands of transactions/s) ? > Here's mine

pgbench results

2008-03-10 Thread Ivan Voras
Hi, Has anyone been able to replicate results from http://www.kaltenbrunner.cc/blog/index.php?/archives/21-guid.html, or get close to the performance described there on similar hardware (e.g. thousands of transactions/s) ? signature.asc Description: OpenPGP digital signature