| From: | Stuart Bishop <stuart(at)stuartbishop(dot)net> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Mount database on RAM disk? |
| Date: | 2005-07-08 01:32:40 |
| Message-ID: | 42CDD7B8.6050109@stuartbishop.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)stuartbishop(dot)net>
http://www.stuartbishop.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2005-07-08 03:05:42 | Re: Mount database on RAM disk? |
| Previous Message | Josh Berkus | 2005-07-08 01:04:28 | Re: Need suggestion high-level suggestion on how to solve a performance problem |