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 reliably for database use such

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 Maxtor

Re: [PERFORM] Auto Vacuum out of memory

2010-02-21 Thread Robert Haas
On Mon, Feb 15, 2010 at 3:20 PM, Rose Zhou r...@anatec.com 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,

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

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