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

Re: optimizing selects on time-series data in Pg

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: Aditya <aditya(at)grot(dot)org>
Cc: sfpug(at)postgresql(dot)org
Subject: Re: optimizing selects on time-series data in Pg
Date: 2003-08-12 03:50:32
Message-ID: 20030812035032.GA82366@perrin.int.nxad.com (view raw or flat)
Thread:
Lists: sfpug
> >   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
effective_cache_size:

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

-- 
Sean Chittenden

In response to

Responses

sfpug by date

Next:From: AdityaDate: 2003-08-12 16:44:48
Subject: Re: optimizing selects on time-series data in Pg
Previous:From: David WheelerDate: 2003-08-09 20:05:08
Subject: Re: NOT IN Optmization

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