pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chris Travers <chris@travelamericas.com>
To: Steve Lane <slane@soliantconsulting.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Indexes on RAM disk = insanity?
Date: Fri, 29 Jul 2005 09:50:07 -0700
Message-ID: <42EA5E3F.4090909@travelamericas.com> (raw)
In-Reply-To: <BF0FC44C.1F03C%slane@soliantconsulting.com>
References: <BF0FC44C.1F03C%slane@soliantconsulting.com>

Steve Lane wrote:

>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?
>  
>
I am quite wary about putting the indexes on a RAM DISK for another reason.

You say that RAM is your bottleneck, so putting anything unnecessary in 
RAM seems like a good way to get less performance rather than more.  
Additionally you have some overhead in tracking the files, etc. and they 
will remain in RAM even when they are not used.  This leaves the system 
with less effective RAM for the memory intensive operations.

Such a move might make a lot of sense if you had a LOT of RAM but disk 
I/O was the bottleneck.  However, if a lack of RAM is your problem, 
putting more stuff in RAM doesn't seem very sound to me. 

Best Wishes,
Chris Travers
Metatron Technology Consulting



view thread (6+ messages)  latest in thread

Message-ID: <42EA5E3F.4090909@travelamericas.com>
Permalink:  ../42EA5E3F.4090909@travelamericas.com/
Also on:    postgresql.org/message-id/42EA5E3F.4090909@travelamericas.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: chris@travelamericas.com, slane@soliantconsulting.com
  Subject: Re: Indexes on RAM disk = insanity?
  In-Reply-To: <42EA5E3F.4090909@travelamericas.com>
  References: <BF0FC44C.1F03C%slane@soliantconsulting.com> <42EA5E3F.4090909@travelamericas.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox