Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 58F04475F5A for ; Tue, 14 Jan 2003 13:32:03 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id F0E0F476E48 for ; Tue, 14 Jan 2003 13:30:46 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18YVpm-0006Vm-00 for ; Tue, 14 Jan 2003 13:30:46 -0500 Date: Tue, 14 Jan 2003 13:30:46 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Sun vs. Mac - best Postgres platform? Message-ID: <20030114133046.T5335@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <1042572384.15544.84.camel@huli> <20030114181054.25701.qmail@web21109.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20030114181054.25701.qmail@web21109.mail.yahoo.com>; from captainx0r@yahoo.com on Tue, Jan 14, 2003 at 10:10:54AM -0800 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/101 X-Sequence-Number: 748 On Tue, Jan 14, 2003 at 10:10:54AM -0800, CaptainX0r wrote: > > could you post your $PGDATA/postgresql.conf for our viewing > > pleasure ? > > max_connections = 64 > shared_buffers = 65536 # 1/2 total RAM /8K > sort_mem = 100000 # min 64, size in KB ^^^^^^ There's your problem. Don't set that anywhere near that high. If you run 2 queries that require sorting, _each sort_ can use up to 100000 K. Which can chew up all your memory pretty fast. > effective_cache_size = 65536 # typically 8KB each What basis did you have to change this? Have you done work figuring out how big the kernel's disk cache is regularly on that system? > Hannu brings up a good point - one that was debated before my > attempts at making Solaris faster. If you were going to make a > fast postgres server what would you use? Assuming you could > afford a SunFire 280R (~$8k?), would that money be better spent > on a (say) Dell server running (say) linux? We're doing light I've been finding FreeBSD way faster than Linux. But yes. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110