Re: [PERFORM] SSD + RAID

2010-02-21 Thread Arjen van der Meijden
On 22-2-2010 6:39 Greg Smith wrote: But the point of this whole testing exercise coming back into vogue again is that SSDs have returned this negligent behavior to the mainstream again. See http://opensolaris.org/jive/thread.jspa?threadID=121424 for a discussion of this in a ZFS context just last

Re: [PERFORM] SSD + RAID

2010-02-21 Thread Greg Smith
Ron Mayer wrote: Bruce Momjian wrote: Agreed, thought I thought the problem was that SSDs lie about their cache flush like SATA drives do, or is there something I am missing? There's exactly one case I can find[1] where this century's IDE drives lied more than any other drive with a ca

Re: [PERFORM] Auto Vacuum out of memory

2010-02-21 Thread Robert Haas
On Mon, Feb 15, 2010 at 3:20 PM, Rose Zhou wrote: > We bought a new WinXP x64 Professional, it has 12GB memory. > > I installed postgresql-8.4.1-1-windows version on this PC, also installed > another .Net application which reads in data from a TCP port and > insert/update the database, the data vo

Re: [PERFORM] SSD + RAID

2010-02-21 Thread Ron Mayer
Bruce Momjian wrote: > Agreed, thought I thought the problem was that SSDs lie about their > cache flush like SATA drives do, or is there something I am missing? There's exactly one case I can find[1] where this century's IDE drives lied more than any other drive with a cache: Under 120GB Maxto

Re: [PERFORM] SSD + RAID

2010-02-21 Thread Bruce Momjian
Scott Carey wrote: > On Feb 20, 2010, at 3:19 PM, Bruce Momjian wrote: > > > Dan Langille wrote: > >> -BEGIN PGP SIGNED MESSAGE- > >> Hash: SHA1 > >> > >> Bruce Momjian wrote: > >>> Matthew Wakeling wrote: > On Fri, 13 Nov 2009, Greg Smith wrote: > > In order for a drive to work r

Re: [PERFORM] SSD + RAID

2010-02-21 Thread Scott Carey
On Feb 20, 2010, at 3:19 PM, Bruce Momjian wrote: > Dan Langille wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> Bruce Momjian wrote: >>> Matthew Wakeling wrote: On Fri, 13 Nov 2009, Greg Smith wrote: > In order for a drive to work reliably for database use such as for