X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3FF6BD1D2DF for ; Tue, 3 Feb 2004 13:36:04 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18445-05 for ; Tue, 3 Feb 2004 09:36:02 -0400 (AST) Received: from ms-smtp-03.tampabay.rr.com (ms-smtp-03-smtplb.tampabay.rr.com [65.32.5.133]) by svr1.postgresql.org (Postfix) with ESMTP id 2A022D1D120 for ; Tue, 3 Feb 2004 09:35:58 -0400 (AST) Received: from unity.basin.cultured.net (24161231hfc249.tampabay.rr.com [24.161.231.249]) by ms-smtp-03.tampabay.rr.com (8.12.10/8.12.7) with ESMTP id i13DZv1c004905; Tue, 3 Feb 2004 08:35:57 -0500 (EST) Subject: Re: cache whole data in RAM From: Chris Trawick To: David Teran Cc: PgSQL Performance ML In-Reply-To: <13E980A8-5648-11D8-BC99-000A95A6F0DC@cluster9.com> References: <13E980A8-5648-11D8-BC99-000A95A6F0DC@cluster9.com> Content-Type: text/plain Message-Id: <1075815126.15880.0.camel@unity.basin.cultured.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 03 Feb 2004 08:32:07 -0500 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/36 X-Sequence-Number: 5560 Put it on a RAM disk. chris On Tue, 2004-02-03 at 07:54, David Teran wrote: > Hi, > > we are trying to speed up a database which has about 3 GB of data. The > server has 8 GB RAM and we wonder how we can ensure that the whole DB > is read into RAM. We hope that this will speed up some queries. > > regards David > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >