Skip site navigation (1) Skip section navigation (2)

Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: josh(at)agliodbs(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Darcy Buskermolen <darcy(at)wavefire(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
Date: 2004-03-24 09:09:02
Message-ID: 4061502E.6030201@paradise.net.nz (view raw or flat)
Thread:
Lists: pgsql-performance

Josh Berkus wrote:

> Forget hyperthreading. Look at their postgresql.conf settings. 8mb shared
>
>mem, 16mb sort mem per connection for 512 connections, default 
>effective_cache_size.    
>
>  
>
Umm...its 64Mb shared buffers isn't it ?

However agree completely with general thrust of message.... particularly 
the 16Mb of sort mem / connection - a very bad idea unless you are 
running a data warehouse box for only a few users (not 512 of them...)

regards

Mark


In response to

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2004-03-24 09:26:27
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
Previous:From: Mark KirkwoodDate: 2004-03-24 08:53:31
Subject: Re: [PERFORM] Benchmarking postgres on Solaris/Linux

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group