Re: postgresql benchmarking

2007-03-14 Thread Kris Kennaway
On Wed, Mar 14, 2007 at 07:41:47PM +0100, Edwin Mons wrote: > Angelo wrote: > > Hi, > > > > Can somebody give more information about this update_process_titles > > setting? > > I suppose there is a mispell and Google is not really helping with 3 > > results > > in Polish! > > > > Thanks, > > Angelo

Re: postgresql benchmarking

2007-03-14 Thread Edwin Mons
Angelo wrote: > Hi, > > Can somebody give more information about this update_process_titles > setting? > I suppose there is a mispell and Google is not really helping with 3 > results > in Polish! > > Thanks, > Angelo Read my previous post: it's called update_process_title, and according to Kris it

Re: postgresql benchmarking (was: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64)

2007-03-14 Thread Angelo
Hi, Can somebody give more information about this update_process_titles setting? I suppose there is a mispell and Google is not really helping with 3 results in Polish! Thanks, Angelo On 3/14/07, Kris Kennaway <[EMAIL PROTECTED]> wrote: On Wed, Mar 14, 2007 at 06:47:23AM -0400, Mike Tancsa wr

Re: postgresql benchmarking (was: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64)

2007-03-14 Thread Kris Kennaway
On Wed, Mar 14, 2007 at 06:47:23AM -0400, Mike Tancsa wrote: > At 03:16 AM 3/14/2007, Kris Kennaway wrote: > > > >On the pgsql side, disable the update_process_titles option (or > >whatever it is called), because this has a 33% performance overhead > > Hi, > Is this a version specific co

Re: postgresql benchmarking

2007-03-14 Thread Edwin Mons
Mike Tancsa wrote: > At 08:30 AM 3/14/2007, Edwin Mons wrote: >> Mike Tancsa wrote: >> > At 03:16 AM 3/14/2007, Kris Kennaway wrote: >> > >> > >> >> On the pgsql side, disable the update_process_titles option (or >> >> whatever it is called), because this has a 33% performance overhead >> > >> > Hi

Re: postgresql benchmarking

2007-03-14 Thread Mike Tancsa
At 08:30 AM 3/14/2007, Edwin Mons wrote: Mike Tancsa wrote: > At 03:16 AM 3/14/2007, Kris Kennaway wrote: > > >> On the pgsql side, disable the update_process_titles option (or >> whatever it is called), because this has a 33% performance overhead > > Hi, > Is this a version specific conf

Re: postgresql benchmarking

2007-03-14 Thread Edwin Mons
Mike Tancsa wrote: > At 03:16 AM 3/14/2007, Kris Kennaway wrote: > > >> On the pgsql side, disable the update_process_titles option (or >> whatever it is called), because this has a 33% performance overhead > > Hi, > Is this a version specific config option or compile ? I cant > find anythi

Re: postgresql benchmarking (was: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64)

2007-03-14 Thread Mike Tancsa
At 03:16 AM 3/14/2007, Kris Kennaway wrote: On the pgsql side, disable the update_process_titles option (or whatever it is called), because this has a 33% performance overhead Hi, Is this a version specific config option or compile ? I cant find anything like that in the .conf or man

Re: postgresql benchmarking

2007-03-13 Thread Kris Kennaway
; > > On the same test postgresql is indeed faster, I haven't finished > > > > benchmarking it yet though. > > > > > > Kris, I'm interested at postgresql benchmarking at two-xeon-quad-core > > > server with 3WARE RAID adapter. Can you give me som

Re: postgresql benchmarking

2007-03-13 Thread Boris Samorodov
; > > benchmarking it yet though. > > > > Kris, I'm interested at postgresql benchmarking at two-xeon-quad-core > > server with 3WARE RAID adapter. Can you give me some tips? > > Thank you. > Well I'm using sysbench and the collection of patches in my > kris

Re: postgresql benchmarking (was: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64)

2007-03-13 Thread Kris Kennaway
> > benchmarking it yet though. > > Kris, I'm interested at postgresql benchmarking at two-xeon-quad-core > server with 3WARE RAID adapter. Can you give me some tips? > Thank you. Well I'm using sysbench and the collection of patches in my kris-contention p4 branch. Sorry

postgresql benchmarking (was: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64)

2007-03-13 Thread Boris Samorodov
(transferring the thread from freebsd-stable@ to freebsd-performance@) On Tue, 13 Mar 2007 20:55:46 -0400 Kris Kennaway wrote: > On the same test postgresql is indeed faster, I haven't finished > benchmarking it yet though. Kris, I'm interested at postgresql benchmarking at tw