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

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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Darcy Buskermolen <darcy(at)wavefire(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
Date: 2004-03-23 22:55:08
Message-ID: 200403231455.08334.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Tom,

> Hm.  What happens if you turn off the hyperthreading?

Forget hyperthreading.   Look at their postgresql.conf settings.   8mb shared 
mem, 16mb sort mem per connection for 512 connections, default 
effective_cache_size.    

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2004-03-23 23:00:40
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
Previous:From: Tom LaneDate: 2004-03-23 22:52:36
Subject: Re: atrocious update performance

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