From: Joshua D. Drake <jd@commandprompt.com>
To: Stuart Bishop <stuart@stuartbishop.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Mount database on RAM disk?
Date: Thu, 07 Jul 2005 20:05:42 -0700
Message-ID: <42CDED86.3000108@commandprompt.com> (raw)
In-Reply-To: <42CDD7B8.6050109@stuartbishop.net>
References: <42CDD7B8.6050109@stuartbishop.net>
Stuart Bishop wrote:
> I'm putting together a road map on how our systems can scale as our load
> increases. As part of this, I need to look into setting up some fast read
> only mirrors of our database. We should have more than enough RAM to fit
> everything into memory. I would like to find out if I could expect better
> performance by mounting the database from a RAM disk, or if I would be
> better off keeping that RAM free and increasing the effective_cache_size
> appropriately.
In theory yes if you can fit the entire database onto a ram disk then
you would see a performance benefit.
Sincerely,
Joshua D. Drake
>
> I'd also be interested in knowing if this is dependant on whether I am
> running 7.4, 8.0 or 8.1.
>
>
--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, stuart@stuartbishop.net
Subject: Re: Mount database on RAM disk?
In-Reply-To: <42CDED86.3000108@commandprompt.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