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

Re: optimizing selects on time-series data in Pg

From: Josh Berkus <josh(at)agliodbs(dot)com>
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-01 18:05:22
Message-ID: 200308011105.22146.josh@agliodbs.com (view raw or flat)
Thread:
Lists: sfpug
Aditya,

>   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 ...

> 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).

Mind checking TOP to see how much RAM your other processes on this server eat?  
That will give us a good baseline for figuring out how much memory to give 
Postgres.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

sfpug by date

Next:From: Stephan SzaboDate: 2003-08-01 18:07:41
Subject: Re: optimizing selects on time-series data in Pg
Previous:From: AdityaDate: 2003-08-01 17:51:48
Subject: Re: optimizing selects on time-series data in Pg

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