Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3C77D476538 for ; Mon, 20 Jan 2003 04:41:31 -0500 (EST) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by postgresql.org (Postfix) with ESMTP id 6A1B947646C for ; Mon, 20 Jan 2003 04:41:24 -0500 (EST) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030120094126.LQFD8666.lakemtao03.cox.net@[192.168.1.1]> for ; Mon, 20 Jan 2003 04:41:26 -0500 Subject: Very large caches (was Re: 7.3.1 New install, large queries are slow) From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <27220.1043046883@sss.pgh.pa.us> References: <3E2BE5DD.30158.D375D9A@localhost> <27220.1043046883@sss.pgh.pa.us> Content-Type: text/plain Organization: Message-Id: <1043055681.15592.156.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 20 Jan 2003 03:41:21 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/203 X-Sequence-Number: 850 On Mon, 2003-01-20 at 01:14, Tom Lane wrote: > "Shridhar Daithankar" writes: > > On 17 Jan 2003 at 12:33, Tom Lane wrote: [snip] > > and that is also the only way to make postgresql use more than couple of gigs > > of RAM, isn't it? > > It seems quite unrelated. The size of our shared memory segment is > limited by INT_MAX --- chopping it up differently won't change that. > > In any case, I think worrying because you can't push shared buffers > above two gigs is completely wrongheaded, for the reasons already > discussed in this thread. The notion that Postgres can't use more > than two gig because its shared memory is limited to that is > *definitely* wrongheaded. We can exploit however much memory your > kernel can manage for kernel disk cache. http://www.redhat.com/services/techsupport/production/GSS_caveat.html "RAM Limitations on IA32 Red Hat Linux releases based on the 2.4 kernel -- including Red Hat Linux 7.1, 7.2, 7.3 and Red Hat Linux Advanced Server 2.1 -- support a maximum of 16GB of RAM." 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? -- +------------------------------------------------------------+ | Ron Johnson, Jr. mailto:ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | "Basically, I got on the plane with a bomb. Basically, I | | tried to ignite it. Basically, yeah, I intended to damage | | the plane." | | RICHARD REID, who tried to blow up American Airlines | | Flight 63 | +------------------------------------------------------------+