Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group