Re: postgresql-performance using sysbench

2008-02-05 Thread Mike Tancsa
At 04:31 AM 1/30/2008, Kris Kennaway wrote: Claus Guttesen wrote: I forgot to mention in my first post that I'm using ULE. The p800 controller has a (factory set) 25/75 read/write cache ratio. There's maybe one additional thing: do you dual-boot Linux and FreeBSD? If so, you'll need to set up a

Re: postgresql-performance using sysbench

2008-02-01 Thread Claus Guttesen
> Just a thought on the effect that HZ has on filesystem (and overall) > performance : > Linux has sort of backtracked from defaulting to HZ=1000 and enable it > only on kernels compiled > for "Desktop" work, and setting HZ=250 for the "Server" profile. I'm doing some db-imports on postgresql on a

Re: postgresql-performance using sysbench

2008-01-31 Thread Ivan Voras
On 31/01/2008, Niki Denev <[EMAIL PROTECTED]> wrote: > On Jan 31, 2008 10:16 PM, Ivan Voras <[EMAIL PROTECTED]> wrote: > > Niki Denev wrote: > > > > > HZ=1000 > > > Time: > > > 239 seconds total > > > 122 seconds of transactions (4 per second) > > > > > What do you think? > > > > Th

Re: postgresql-performance using sysbench

2008-01-31 Thread Niki Denev
On Jan 31, 2008 10:16 PM, Ivan Voras <[EMAIL PROTECTED]> wrote: > Niki Denev wrote: > > > HZ=1000 > > Time: > > 239 seconds total > > 122 seconds of transactions (4 per second) > > > What do you think? > > This is a very low result :) I don't know your machine or the parameters > yo

Re: postgresql-performance using sysbench

2008-01-31 Thread Ivan Voras
Niki Denev wrote: HZ=1000 Time: 239 seconds total 122 seconds of transactions (4 per second) What do you think? This is a very low result :) I don't know your machine or the parameters you used with postmark but even FreeBSD on two striped 7.5 kRPM drives can achieve ~~ 11

Re: postgresql-performance using sysbench

2008-01-31 Thread Niki Denev
On Jan 30, 2008 9:57 PM, Ivan Voras <[EMAIL PROTECTED]> wrote: > On 30/01/2008, Kris Kennaway <[EMAIL PROTECTED]> wrote: > > > Rewrite of the lockmgr primitive, for starters. Then we'll see what > > remains. > > Ok, I know about the lockmgr efforts, and they will surely help some > loads. I'll try

Re: postgresql-performance using sysbench

2008-01-30 Thread Ivan Voras
On 30/01/2008, Kris Kennaway <[EMAIL PROTECTED]> wrote: > Rewrite of the lockmgr primitive, for starters. Then we'll see what > remains. Ok, I know about the lockmgr efforts, and they will surely help some loads. I'll try to compile the results I've been talking about in a few days and post them

Re: postgresql-performance using sysbench

2008-01-30 Thread Kris Kennaway
Ivan Voras wrote: Kris Kennaway wrote: Write performance is something that we are working on, expect to hear about progress over the coming weeks/months. Do you have some notes or descriptions about what is being worked on? I'm currently doing some file system benchmarking for internal purpos

Re: postgresql-performance using sysbench

2008-01-30 Thread Ivan Voras
Kris Kennaway wrote: > Write performance is something that we are working on, expect to hear > about progress over the coming weeks/months. Do you have some notes or descriptions about what is being worked on? I'm currently doing some file system benchmarking for internal purposes and I'm seeing

Re: postgresql-performance using sysbench

2008-01-30 Thread Kris Kennaway
Claus Guttesen wrote: I forgot to mention in my first post that I'm using ULE. The p800 controller has a (factory set) 25/75 read/write cache ratio. There's maybe one additional thing: do you dual-boot Linux and FreeBSD? If so, you'll need to set up a separate additional partition for the databa

Re: postgresql-performance using sysbench

2008-01-29 Thread Mark Kirkwood
Mike Tancsa wrote: At 03:46 PM 1/28/2008, Claus Guttesen wrote: I had (allready) saved the thread in my mail-account so I could look it up before I started testing. :-) So I compiled postgresql with the option WITH_THREADSAFE=true and used sysbench with --pgsql-host="" . As pointed out by Ivan

Re: postgresql-performance using sysbench

2008-01-29 Thread Mike Tancsa
At 03:46 PM 1/28/2008, Claus Guttesen wrote: I had (allready) saved the thread in my mail-account so I could look it up before I started testing. :-) So I compiled postgresql with the option WITH_THREADSAFE=true and used sysbench with --pgsql-host="" . As pointed out by Ivan my test also involve

Re: postgresql-performance using sysbench

2008-01-29 Thread Claus Guttesen
> >I had (allready) saved the thread in my mail-account so I could look > >it up before I started testing. :-) So I compiled postgresql with the > >option WITH_THREADSAFE=true and used sysbench with --pgsql-host="" . > >As pointed out by Ivan my test also involved r/w whereas the thread > >you (pro

Re: postgresql-performance using sysbench

2008-01-29 Thread Claus Guttesen
> > I forgot to mention in my first post that I'm using ULE. The p800 > > controller has a (factory set) 25/75 read/write cache ratio. > > There's maybe one additional thing: do you dual-boot Linux and FreeBSD? > If so, you'll need to set up a separate additional partition for the > database, inste

Re: postgresql-performance using sysbench

2008-01-29 Thread Ivan Voras
> I had (allready) saved the thread in my mail-account so I could look > it up before I started testing. :-) So I compiled postgresql with the > option WITH_THREADSAFE=3Dtrue and used sysbench with --pgsql-host=3D"" = =2E > As pointed out by Ivan my test also involved r/w whereas the thread > you (

Re: postgresql-performance using sysbench

2008-01-28 Thread Claus Guttesen
> Ubuntu 7.10: > > grep "transactions:" sysbench-clients-24|sort > transactions:1 (2354.49 per sec.) > transactions:10001 (2126.28 per sec.) > transactions:10001 (2215.52 per sec.) > tr

Re: postgresql-performance using sysbench

2008-01-28 Thread Kris Kennaway
Claus Guttesen wrote: Ubuntu 7.10: grep "transactions:" sysbench-clients-24|sort transactions:1 (2354.49 per sec.) transactions:10001 (2126.28 per sec.) transactions:10001 (2215.52 per sec.) transactions:

Re: postgresql-performance using sysbench

2008-01-28 Thread Claus Guttesen
> > > Ubuntu 7.10: > > > > > > grep "transactions:" sysbench-clients-24|sort > > > transactions:1 (2354.49 per sec.) > > > transactions:10001 (2126.28 per sec.) > > > transactions:10001 (2215.52 per sec.) > > > transacti

Re: postgresql-performance using sysbench

2008-01-28 Thread Darcy Buskermolen
On Monday 28 January 2008 09:25:13 Ivan Voras wrote: > Claus Guttesen wrote: > > Ubuntu 7.10: > > > > grep "transactions:" sysbench-clients-24|sort > > transactions:1 (2354.49 per sec.) > > transactions:10001 (2126.28 per sec.) > > transactions:

Re: postgresql-performance using sysbench

2008-01-28 Thread Ivan Voras
Claus Guttesen wrote: Ubuntu 7.10: grep "transactions:" sysbench-clients-24|sort transactions:1 (2354.49 per sec.) transactions:10001 (2126.28 per sec.) transactions:10001 (2215.52 per sec.) transactions:

postgresql-performance using sysbench

2008-01-28 Thread Claus Guttesen
Hi. I have a HP DL360 G5 with a p800 controller with 512 bbwc and a msa70 cabinet with eight 15K rpm sas-disks in raid 1+0. I installed FreeBSD 7.0 stable and ubuntu 7.10 server using postgresql 8.2.5 (from ports on FreeBSD and as an install-option on ubuntu). Both releases are amd64. Postgresql o