> > shared_buffers = 128 # 2*max_connections, min 16 (default 64)
> > ...
> > #effective_cache_size = 1000 # default in 8k pages
> You could certainly stand to raise these, unless your system is low
> on RAM ...
Using /bin/sh, plop the following in to determine your
echo "effective_cache_size = $((`sysctl -n vfs.hibufspace` / 8192))"
> > PIII-800/512MB RAM running FreeBSD 4-STABLE with the database data
> > files NFS mounted via a 100Mbps/full-duplex private network from a
> > lightly-loaded Network Appliance F87 fileserver (I'm pretty
> > certain that we're not IO bound).
FWIW, NFS + DB server is a bad idea for file locking reasons. -sc
In response to
sfpug by date
|Next:||From: Aditya||Date: 2003-08-12 16:44:48|
|Subject: Re: optimizing selects on time-series data in Pg|
|Previous:||From: David Wheeler||Date: 2003-08-09 20:05:08|
|Subject: Re: NOT IN Optmization|