From: Stuart Bishop <stuart@stuartbishop.net>
To: pgsql-performance@postgresql.org
Subject: Mount database on RAM disk?
Date: Fri, 08 Jul 2005 11:32:40 +1000
Message-ID: <42CDD7B8.6050109@stuartbishop.net> (raw)
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.
I'd also be interested in knowing if this is dependant on whether I am
running 7.4, 8.0 or 8.1.
--
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/Attachments:
signature.asc (application/pgp-signature, 188B) download
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: stuart@stuartbishop.net
Subject: Re: Mount database on RAM disk?
In-Reply-To: <42CDD7B8.6050109@stuartbishop.net>
* 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