X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 601DBD1C91F for ; Sun, 27 Jul 2003 16:20:10 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 11817-10 for ; Sun, 27 Jul 2003 13:19:16 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 262AED1C4BA for ; Sun, 27 Jul 2003 13:20:08 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6RGIqQ3009003; Sun, 27 Jul 2003 12:18:53 -0400 (EDT) To: Daniel Migowski Cc: pgsql-performance@postgresql.org Subject: Re: Mapping a database completly into Memory In-reply-to: <97842368.20030727104901@artis.uni-oldenburg.de> References: <97842368.20030727104901@artis.uni-oldenburg.de> Comments: In-reply-to Daniel Migowski message dated "Sun, 27 Jul 2003 10:49:01 +0200" Date: Sun, 27 Jul 2003 12:18:52 -0400 Message-ID: <9002.1059322732@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/435 X-Sequence-Number: 2728 Daniel Migowski writes: > I just wondered if there is a possibility to map my database running > on a linux system completly into memory and to only use disk > accesses for writes. That happens for free, if you have enough RAM. The kernel will use spare RAM to hold copies of every disk block it's ever read. regards, tom lane