X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BBB4511F60AF for ; Fri, 7 Apr 2006 14:11:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90598-05 for ; Fri, 7 Apr 2006 14:11:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from peufeu.com (boutiquenumerique.com [82.67.9.10]) by postgresql.org (Postfix) with ESMTP id 7C9C111F65C7 for ; Fri, 7 Apr 2006 14:11:40 -0300 (ADT) Received: (qmail 4826 invoked from network); 7 Apr 2006 19:12:13 +0200 Received: from boutiquenumerique.com (HELO apollo13) (82.67.9.10) by boutiquenumerique.com with SMTP; 7 Apr 2006 19:12:13 +0200 To: "Matt Davies | Postgresql List" , "Charles A. Landemaine" Cc: pgsql-performance@postgresql.org Subject: Re: Loading the entire DB into RAM References: <44367D22.9060007@mattdavies.net> Message-ID: Date: Fri, 07 Apr 2006 19:12:12 +0200 From: PFC Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <44367D22.9060007@mattdavies.net> User-Agent: Opera M2/8.51 (Linux, build 1462) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200604/142 X-Sequence-Number: 18226 ** This has not been tested. Create a ramdisk of required size Create a Linux software RAID mirror between the ramdisk, and a partition of the same size. Mark the physical-disk as write-mostly (reads will go to the ramdisk) Format it and load data... On reboot you'll get a RAID1 mirror with 1 failed drive (because the ramdisk is dead of course). Just recreate the ramdisk and resync.