Re: performance tuning: shared_buffers, sort_mem; swap

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: performance tuning: shared_buffers, sort_mem; swap
Date: 2002-08-13 17:03:48
Message-ID: 20020813130348.I31856@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2002-08-13 17:06:23 Re: tuning postgresql
Previous Message Tom Lane 2002-08-13 16:56:25 Re: performance tuning: shared_buffers, sort_mem; swap