On Tue, 2004-05-18 at 14:12, Doug Y wrote:
Run a query I've been having trouble with and watch the output of vmstat
(linux):
$ vmstat 1
procs memoryswap io system
cpu
r b w swpd free buff cache si sobibo incs us
sy
Well,
Since I haven't seen any other responds, I'll offer a bit of advice and let
others correct me. :)
Your shared buffers may be too big (?). It is much larger than the guide
on varlena.com recommends. All I can suggest is trying some experiments
with halving/doubling the numbers to see
Hello,
(note best viewed in fixed-width font)
I'm still trying to find where my performance bottle neck is...
I have 4G ram, PG 7.3.4
shared_buffers = 75000
effective_cache_size = 75000
Run a query I've been having trouble with and watch the output of vmstat
(linux):
$ vmstat 1
procs