> 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.
(under "Memory"), it says that sort_mem is set in KB. Is this document
wrong (or outdated)?
In response to
pgsql-performance by date
|Next:||From: Gaetano Mendola||Date: 2004-05-07 23:35:44|
|Subject: Re: [OFF-TOPIC] - Known maximum size of the|
|Previous:||From: scott.marlowe||Date: 2004-05-07 16:00:03|
|Subject: Re: Help how to tune-up my Database|