X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9FA8152A2A for ; Fri, 29 Jul 2005 12:33:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71187-01 for ; Fri, 29 Jul 2005 15:33:28 +0000 (GMT) Received: from mammoth.utopiasystems.net (meridian1.utopiasystems.net [66.150.45.40]) by svr1.postgresql.org (Postfix) with ESMTP id 2C52952A15 for ; Fri, 29 Jul 2005 12:33:27 -0300 (ADT) Received: from 68.54.143.76 ([68.54.143.76]) by mammoth.utopiasystems.net ([172.16.1.40]) via Exchange Front-End Server mail.utopiasystems.net ([172.16.1.42]) with Microsoft Exchange Server HTTP-DAV ; Fri, 29 Jul 2005 15:31:12 +0000 User-Agent: Microsoft-Entourage/11.1.0.040913 Date: Fri, 29 Jul 2005 11:32:28 -0400 Subject: Indexes on RAM disk = insanity? From: Steve Lane To: Message-ID: In-Reply-To: <200507291425.j6TEP4028656@candle.pha.pa.us> Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.581 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200507/248 X-Sequence-Number: 18304 All: We have a postgres 7.4 server where we're trying to achieve some speedups. Right now, at least superficially, RAM appears to be the bottleneck -- lots of swaps in and out. There is another consultant beside myself in the mix and he asked this question: can we put the database indexes on a RAM disk? Won't that speed things up? My first instinct is NEVER NEVER NEVER to put any database data in volatile storage like that. But on second thought, I thought I'd ask. Is this crazy? If one did it, how would you handle repopulating the indexes if the RAM disk were lost? Just have a shell script that would do that automatically? Or will postgres 8 rebuild an index if it doesn't find it where it expects? I recognize, or think I do, that PG 8 tablespaces would be required to accomplish this. Would this be insane? Has anyone done it? -------- Steve Lane Vice President Soliant Consulting, Inc. (312) 850-3830 (V) (312) 850-3930 (F) slane@soliantconsulting.com