Re: Optimize

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Torsten Schulz <comic(at)be-a-part(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimize
Date: 2003-11-24 21:45:44
Message-ID: Pine.LNX.4.44.0311242242440.29118-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, 24 Nov 2003, Torsten Schulz wrote:

> sort_mem = 32768 # min 32

32 meg per sort can be a lot in total if you have many clients sorting
things. I assume you have checked so that the computer is not pushed into
swapping when you have the peak with lots of users. A swapping computer is
never fast.

Using some swap space is not bad, but a lot of page in and page out to the
swap is not good.

--
/Dennis

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message MK Spam 2003-11-24 22:03:17 Where to start for performance problem?
Previous Message Torsten Schulz 2003-11-24 21:33:05 Re: Optimize