Re: Maximum Possible Insert Performance?

On Mon, 2003-11-24 at 19:16, Greg Stark wrote:
> William Yu <wyu@talisys.com> writes:
> 
> > > You're right, though, mirroring a solid state drive is pretty pointless; if
> > > power fails, both mirrors are dead.
> > 
> > Actually no. Solid state memory is non-volatile. They retain data even without
> > power.
> 
> Note that flash ram only has a finite number of write cycles before it fails.
> 
> On the other hand that might not be so bad for WAL which writes sequentially,
> you can easily calculate how close you are to the maximum. For things like
> heap storage or swap it's awful as you can get hot spots that get written to
> thousands of times before the rest of the space is used.

I could be wrong, but I was under the impression that most of the newer
flash disks tended to spread writes out over the drive so that hotspots
are minimized.  

-- 
Suchandra Thapa <ssthapa@netzero.com>