I have a long, computationally intensive query I am running on Ubuntu
Linux 64bit, 8G ram
PostgreSQL 9, PostGIS trunk. I have a question about memory usage and
setttings..
postgresql.conf memory related settings:
work_mem = 512M
shared_buffers =
Brian,
* Brian Hamlin (mapl...@light42.com) wrote:
I am guessing that work_mem is the wildcard that is causing the
large allocations..
Comments / Suggestions on this ?
Yes, work_mem is used to determine, for each sort/hash/etc, if it
should be done in-memory or done on disk. If you have a