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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly