X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 47FE43A4ECF for ; Sun, 21 Nov 2004 01:42:46 +0000 (GMT) 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 03974-10 for ; Sun, 21 Nov 2004 01:42:35 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id C1E7E3A4ECB for ; Sun, 21 Nov 2004 01:42:38 +0000 (GMT) Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6690860; Sat, 20 Nov 2004 17:44:09 -0800 From: Josh Berkus Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Re: tablespace + RAM disk? Date: Sat, 20 Nov 2004 11:38:43 -0800 User-Agent: KMail/1.6.2 Cc: "David Parker" References: <07FDEE0ED7455A48AC42AC2070EDFF7C26BBCB@corpsrv2.tazznetworks.com> In-Reply-To: <07FDEE0ED7455A48AC42AC2070EDFF7C26BBCB@corpsrv2.tazznetworks.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200411201138.43162.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=DATE_IN_PAST_06_12 X-Spam-Level: X-Archive-Number: 200411/321 X-Sequence-Number: 9275 David, > But, I'm also still interested in the answer to my question: is there > any reason you could not put an 8.0 tablespace on a RAM disk? Some people have *talked* about trying it, but nobody yet has reported back. I can see a few potential problems: 1) The query planner would not be aware, and could not be made aware short of hacking the source, that one tablespace has different access speeds than the others; 2) After a crash, you might be unable to recover that tablespace, and PG would refuse to bring the system back up without it. However, the best thing to do is to try it. Good luck, and do a write-up for us! -- Josh Berkus Aglio Database Solutions San Francisco