Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 637324764E0 for ; Tue, 14 Jan 2003 14:18:56 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 81A0A4764CE for ; Tue, 14 Jan 2003 14:18:53 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18YWaL-0007PS-00 for ; Tue, 14 Jan 2003 14:18:53 -0500 Date: Tue, 14 Jan 2003 14:18:53 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Sun vs. Mac - best Postgres platform? Message-ID: <20030114141853.V5335@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <20030114133046.T5335@mail.libertyrms.com> <20030114190149.7293.qmail@web21104.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: <20030114190149.7293.qmail@web21104.mail.yahoo.com>; from captainx0r@yahoo.com on Tue, Jan 14, 2003 at 11:01:49AM -0800 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/106 X-Sequence-Number: 753 On Tue, Jan 14, 2003 at 11:01:49AM -0800, CaptainX0r wrote: > I changed back to the default 1024, and down to the minimum, 64 > - no change. I think that was changed simultaneously with some > other parameter (bad, I know) that actually had an affect. I > guess I can remove it. Very bad to change two things at once. You think it's saving you time, but now . . . well, you already know what happens ;-) Anyway, you _still_ shouldn't have it that high. > > > effective_cache_size = 65536 # typically 8KB each > > I read somewhere that this should be set to half the system RAM > size, 64k*8k=512m = 1/2 of the 1 Gig RAM. I guess this is way > off since you're saying that it's disk cache. This agrees with > the documentation. I can't really rely on the (precious little > Solaris postgres) info I find on the net.... ;) I think you should rely on the Postgres documentation, which has way fewer errors than just about any other technical documentation I've ever seen. Yes, it's disk cache. I wouldn't set _anything_ to half the system RAM. It'd be real nice if your disk cache was half your RAM, but I'd be amazed if anyone's system were that efficient. It sounds like you need to follow Tom Lane's advice, though, and do some profiling. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110