| From: | Tom Allison <tallison(at)tacocat(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | memory tuning |
| Date: | 2006-06-21 01:33:12 |
| Message-ID: | 4498A1D8.4070508@tacocat.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I have 2 GB of RAM on this machine and a table with 2.9Million rows.
The most I'm getting reported on memory usage for postgres (7.4 can't upgrade
just yet) is 2.6%.
I have set the following parameters:
shared_buffers = 3000 # min 16, at least max_connections*2, 8KB each
sort_mem = 262144 # min 64, size in KB
vacuum_mem = 262144 # min 1024, size in KB
But I'm not utilizing much memory and things are running frighteningly slow.
I did run a VACUUM ANALYZE today with no incidents so I wouldn't expect that to
be a problem. I don't think there have been more than 10^5 transactions since
then (assuming that's not too many?)
tips?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2006-06-21 10:37:30 | Re: memory tuning |
| Previous Message | Richard Broersma Jr | 2006-06-20 21:43:07 | Re: OLE in Postgres? |