| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-08-01 18:07:41 | Re: optimizing selects on time-series data in Pg |
| Previous Message | Aditya | 2003-08-01 17:51:48 | Re: optimizing selects on time-series data in Pg |