Re: [PERFORM] Mount database on RAM disk?

2005-07-09 Thread Christopher Browne
> On 8 Jul 2005, at 20:21, Merlin Moncure wrote: >> 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 b

Re: [PERFORM] Mount database on RAM disk?

2005-07-09 Thread Alex Stapleton
On 8 Jul 2005, at 20:21, Merlin Moncure wrote: Stuart, 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 everythin

Re: [PERFORM] Mount database on RAM disk?

2005-07-08 Thread Merlin Moncure
> Stuart, > > > 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 i

Re: [PERFORM] Mount database on RAM disk?

2005-07-08 Thread Josh Berkus
Stuart, > 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 >

Re: [PERFORM] Mount database on RAM disk?

2005-07-08 Thread Rod Taylor
> If I could get and deploy some SSD (Solid State Disk) devices that > would make this sort of thing *actually safe,* I'd expect that to be a > pretty fabulous improvement, at least for write-heavy database > activity. Not nearly as much as you would expect. For the price of the SSD and a SCSI con

Re: [PERFORM] Mount database on RAM disk?

2005-07-07 Thread Chris Browne
[EMAIL PROTECTED] (Stuart Bishop) writes: > 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 wou

Re: [PERFORM] Mount database on RAM disk?

2005-07-07 Thread Joshua D. Drake
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 co

[PERFORM] Mount database on RAM disk?

2005-07-07 Thread Stuart Bishop
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 perf