Pruteanu Dragos wrote:
> Hi all,
>
> I am running Postgres on a machine with
> 4G of memory.
> When I run
> dbvlm=> SELECT u.email, g.email FROM dom_user u,
> shared_buffers = 200000
> sort_mem = 819200
> vacuum_mem = 819200
What process led you to choose these values? Do you understand the
implications of allocating 1.6GB of memory to shared buffers, along with
over 800MB per sort?
> Any ideea what can be done?
Start by fixing your configuration values - the above are unlikely to be
correct. Then, check to see if all RAM is actually in use, or you have
hit some system-imposed per-user limit.
This might be a useful place to start:
http://www.powerpostgresql.com/PerfList
--
Richard Huxton
Archonet Ltd