Re: [PERFORM] SSD and RAID

2012-03-06 Thread Yeb Havinga
On 2012-03-05 23:37, Mark Kirkwood wrote: Which brings up the question of should it be a pair in RAID 1 or just a singe drive? Traditionally this would have been a no brainer Of course you want RAID 1 or RAID 10! However our experience with SSD failure modes points to firmware bugs as primary

Re: [PERFORM] SSD and RAID

2012-03-06 Thread Yeb Havinga
On 2012-03-06 09:34, Andrea Suisani wrote: On 03/06/2012 09:17 AM, Yeb Havinga wrote: PS: we applied the same philosophy (different brands) also to motherboards, io controllers and memory, but after testing, we liked one IO controllers software so much more than the other so we chose to

Re: [PERFORM] Advice sought : new database server

2012-03-06 Thread Rory Campbell-Lange
On 04/03/12, Rory Campbell-Lange (r...@campbell-lange.net) wrote: I'd be grateful for advice on specifying a new server ... The existing server is a 2 x Quad core E5420 Xeon (2.5GHz) with 8GB of RAM with an LSI battery-backed RAID 10 array of 4no 10K SCSI disks, providing about 230GB of

Re: [PERFORM] Repeat execution of stable expressions

2012-03-06 Thread Merlin Moncure
On Mon, Mar 5, 2012 at 6:41 PM, Peter van Hardenberg p...@pvh.ca wrote: On Mon, Mar 5, 2012 at 3:15 PM, Merlin Moncure mmonc...@gmail.com wrote: I've complained many times that select (f()).*; will execute f() once for each returned field of f() since the server essentially expands that

Re: [PERFORM] Repeat execution of stable expressions

2012-03-06 Thread Jan Otto
hi, I've complained many times that select (f()).*; will execute f() once for each returned field of f() since the server essentially expands that into: select f().a, f().b; try it yourself, see: create function f(a out text, b out text) returns record as $$ begin perform

Re: [PERFORM] Repeat execution of stable expressions

2012-03-06 Thread Merlin Moncure
On Tue, Mar 6, 2012 at 10:21 AM, Jan Otto as...@me.com wrote: hi, I've complained many times that select (f()).*; will execute f() once for each returned field of f() since the server essentially expands that into: select f().a, f().b; try it yourself, see: create function f(a out

Re: [PERFORM] Advice sought : new database server

2012-03-06 Thread Steve Crawford
On 03/04/2012 03:50 AM, Michael Friedl wrote: Hey! On 04.03.2012 10:58, Rory Campbell-Lange wrote: 1U chassis with 8 2.5 disk bays 2x Intel Xeon E5630 Quad-Core / 4x 2.53GHz / 12MB cache 8 channel Areca ARC-1880i (PCI Express x8 card) presumably with BBU (can't see it

Re: [PERFORM] SSD and RAID

2012-03-06 Thread Mark Kirkwood
On 06/03/12 21:17, Yeb Havinga wrote: One thing to note is that linux software raid with md doesn't support discard, which might shorten the drive's expected lifetime. To get some numbers I tested the raid 1 of ssd's setup for mediawear under a PostgreSQL load earlier, see