Re: Help how to tune-up my Database
Bricklen <bricklen-rem@yahoo.comz>
From: Bricklen <bricklen-rem@yahoo.comz>
To: pgsql-performance@postgresql.org
Date: 2004-05-07T16:47:09Z
Lists: pgsql-performance
scott.marlowe wrote: > sort_mem might do with a small bump, especially if you're only handling a > few connections at a time. Be careful, it's per sort, and measured in > megs, so it's easy for folks to set it too high and make their machine > start flushing too much kernel cache, which will slow down the other > backends that have to go to disk for data. <snip> http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html (under "Memory"), it says that sort_mem is set in KB. Is this document wrong (or outdated)?