Re: Optimize - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: Optimize
Date
Msg-id Pine.LNX.4.44.0311242242440.29118-100000@zigo.dhs.org
Whole thread Raw
In response to Re: Optimize  (Torsten Schulz <comic@be-a-part.de>)
List 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


pgsql-performance by date:

Previous
From: Torsten Schulz
Date:
Subject: Re: Optimize
Next
From: Gaetano Mendola
Date:
Subject: Re: Optimize