Skip site navigation (1) Skip section navigation (2)

Re: Indexes on RAM disk = insanity?

From: Richard_D_Levine(at)raytheon(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Indexes on RAM disk = insanity?
Date: 2005-07-29 15:57:46
Message-ID: OF27C7D6BC.D31BF71D-ON0525704D.005776A0-0525704D.0057AFE9@ftw.us.ray.com (view raw or flat)
Thread:
Lists: pgsql-admin
> RAM appears to be the bottleneck -- lots
> of swaps in and out.
> can we put the database indexes on a RAM disk?

Can you increase the RAM in the machine?  I guess I should assume you're
maxed out.

Rick
pgsql-admin-owner(at)postgresql(dot)org wrote on 07/29/2005 10:32:28 AM:

> 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(at)soliantconsulting(dot)com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2005-07-29 16:21:02
Subject: Re: Indexes on RAM disk = insanity?
Previous:From: Scott MarloweDate: 2005-07-29 15:47:35
Subject: Re: postgres optimization

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group