Re: performance tuning: shared_buffers, sort_mem; swap - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: performance tuning: shared_buffers, sort_mem; swap
Date
Msg-id 20020813130348.I31856@mail.libertyrms.com
Whole thread Raw
In response to performance tuning: shared_buffers, sort_mem; swap  (Thomas O'Connell <tfo@monsterlabs.com>)
List pgsql-admin
On Tue, Aug 13, 2002 at 10:42:12AM -0500, Thomas O'Connell wrote:
> the caveat was to watch for swap activity when these values were being
> set. so my question is, how much swapping is too much, and is there a

Any swapping is too much on any system that is supposed to be fast.
Swap overhead is just terrible.  If you're swapping on your Postgres
machine, either find something that you can kill off, or reduce your
shared buffers (or both).

A

--
----
Andrew Sullivan                               87 Mowat Avenue
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance tuning: shared_buffers, sort_mem; swap
Next
From: Andrew Sullivan
Date:
Subject: Re: tuning postgresql