On 8 Jul 2005, at 20:21, Merlin Moncure wrote:


I'm putting together a road map on how our systems can scale as our


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


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,


if I would be better off keeping that RAM free and increasing the
effective_cache_size appropriately.

If you're accessing a dedicated, read-only system with a database


enough to fit in RAM, it'll all be cached there anyway, at least on


and BSD.   You won't be gaining anything by creating a ramdisk.

ditto windows.

Files cached in memory are slower than reading straight from memory but
not nearly enough to justify reserving memory for your use.  In other
words, your O/S is a machine with years and years of engineering
designed best how to dole memory out to caching and various processes.
Why second guess it?

Because sometimes it gets it wrong. The most brutal method is occasionally the most desirable. Even if it not the "right" way to do it.


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to