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: max-cache-size doesn't work with 9.5.0b1

2008-01-29 Thread JINMEI Tatuya / 神明達哉
At Tue, 29 Jan 2008 11:40:39 +0100, Attila Nagy <[EMAIL PROTECTED]> wrote: > >> Without threading I don't see this effect, the memory usage stops at a > >> sane limit and it's size can be affected by setting the max-cache-size > >> option. > >> > >> I don't think you would gain anything usable w

Re: UCD-MIB for bsnmpd?

2008-01-29 Thread Miroslav Lachman
Alan Amesbury wrote: Alan Amesbury wrote: [snip] I'd like to run bsnmpd, but need the UCD-MIB for other performance monitoring. I could run net-snmp and proxy requests through it to bsnmpd, but that strikes me as inelegant. There's a bsnmpd-ucd module at Google http://bsnmp-ucd.goo

newfs locks entire machine for 20seconds

2008-01-29 Thread Steven Hartland
I'm just in the midst of setting up a new machine using 7.0-PRERELEASE and while running newfs to init the data partitions the entire machine stalled for a good 20seconds when processing a 500GB partition. I had a number of windows open at the time including:- 1. gstat 2. top showing IO inc syste

Re: UCD-MIB for bsnmpd?

2008-01-29 Thread Alan Amesbury
Alan Amesbury wrote: [snip] > I'd like to run bsnmpd, but need the UCD-MIB for other performance > monitoring. I could run net-snmp and proxy requests through it to > bsnmpd, but that strikes me as inelegant. There's a bsnmpd-ucd module > at Google > > http://bsnmp-ucd.googlecode.com/ >

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: max-cache-size doesn't work with 9.5.0b1

2008-01-29 Thread Attila Nagy
On 2008.01.28. 19:21, JINMEI Tatuya / 神明達哉 wrote: At Mon, 28 Jan 2008 17:10:28 +0100, Attila Nagy <[EMAIL PROTECTED]> wrote: If you have time, could you rebuild named as follows % STD_CDEFINES='-DLRU_DEBUG' ./configure; make and try again? This won't solve the problem, but provide more de

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 (