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

memory tuning

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 (view raw or flat)
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?

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2006-06-21 10:37:30
Subject: Re: memory tuning
Previous:From: Richard Broersma JrDate: 2006-06-20 21:43:07
Subject: Re: OLE in Postgres?

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