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 95325D1C507 for ; Sun, 27 Jul 2003 08:47:53 +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 99678-03 for ; Sun, 27 Jul 2003 05:47:02 -0300 (ADT) Received: from spv.Informatik.Uni-Oldenburg.DE (spv.Informatik.uni-oldenburg.de [134.106.1.10]) by svr1.postgresql.org (Postfix) with ESMTP id 7CFFDD1C4D6 for ; Sun, 27 Jul 2003 05:47:51 -0300 (ADT) Received: from sibelius.artis.uni-oldenburg.de ([134.106.121.2]) by spv.Informatik.Uni-Oldenburg.DE (Exim 3.16) id 19ghC4-0002JE-00; Sun, 27 Jul 2003 10:47:52 +0200 Received: from 127.0.0.1 (really [134.106.121.91]) by sibelius.artis.uni-oldenburg.de via smail with esmtp id (Debian Smail3.2.0.102) for ; Sun, 27 Jul 2003 10:47:45 +0200 (CEST) Date: Sun, 27 Jul 2003 10:49:01 +0200 From: Daniel Migowski X-Mailer: The Bat! (v1.62r) Educational Reply-To: Daniel Migowski X-Priority: 3 (Normal) Message-ID: <97842368.20030727104901@artis.uni-oldenburg.de> To: pgsql-performance@postgresql.org Subject: Mapping a database completly into Memory MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/430 X-Sequence-Number: 2723 Hallo pgsql-performance, 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. I got a nice machine around with 2 gigs of ram, and my database at the moment uses about 30MB on the disks. Or does Postgresql do this automtatically, with some cache adjusting parameters, and after doing a select * from on my database? Thank you and ciao, Mig-O