Re: Maximum Possible Insert Performance? - Mailing list pgsql-performance

From Suchandra Thapa
Subject Re: Maximum Possible Insert Performance?
Date
Msg-id 1069786793.19104.33.camel@hepcat
Whole thread Raw
In response to Re: Maximum Possible Insert Performance?  (Greg Stark <gsstark@mit.edu>)
List pgsql-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>

Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: duration logging setting in 7.4
Next
From: Steve Atkins
Date:
Subject: Re: For full text indexing, which is better, tsearch2 or