Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 63276476075 for ; Mon, 20 Jan 2003 10:16:45 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 710E1476021 for ; Mon, 20 Jan 2003 10:16:44 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0KFGl5u002996; Mon, 20 Jan 2003 10:16:47 -0500 (EST) To: Ron Johnson Cc: PgSQL Performance ML Subject: Re: Very large caches (was Re: 7.3.1 New install, large queries are slow) In-reply-to: <1043055681.15592.156.camel@haggis> References: <3E2BE5DD.30158.D375D9A@localhost> <27220.1043046883@sss.pgh.pa.us> <1043055681.15592.156.camel@haggis> Comments: In-reply-to Ron Johnson message dated "20 Jan 2003 03:41:21 -0600" Date: Mon, 20 Jan 2003 10:16:47 -0500 Message-ID: <2995.1043075807@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/208 X-Sequence-Number: 855 Ron Johnson writes: > So if I have some honking "big" Compaq Xeon SMP server w/ 16GB RAM, > and top(1) shows that there is 8GB of buffers, then Pg will be happy > as a pig in the mud? Sounds good to me ... regards, tom lane