Re: [PERFORM] Dell Perc HX00 RAID controllers: What's inside?

2010-05-09 Thread Scott Marlowe
On Sun, May 9, 2010 at 3:20 PM, Greg Smith wrote: > Craig James wrote: >> >> Now that it's time to buy a new computer, Dell has changed their RAID >> models from the Perc6 to Perc H200 and such.  Does anyone know what's inside >> these?  I would hope they've stuck with the Megaraid controller... >

Re: [PERFORM] Dell Perc HX00 RAID controllers: What's inside?

2010-05-09 Thread Greg Smith
Craig James wrote: Now that it's time to buy a new computer, Dell has changed their RAID models from the Perc6 to Perc H200 and such. Does anyone know what's inside these? I would hope they've stuck with the Megaraid controller... The H700 and H800 are both based on the LSI 2180 chipset: h

Re: [PERFORM] Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this?

2010-05-09 Thread Oleg Bartunov
Karl, estimation for gin indexes currently is very-very bad, so I don't surprise your result. We'll discuss on pgcon our new ginconstetimate function, which could improve planner. Can you provide us dump of your db (with relevant columns) and test queries, so we could check our new patch. Oleg O

Re: [PERFORM] 8K recordsize bad on ZFS?

2010-05-09 Thread Dimitri
Josh, it'll be great if you explain how did you change the records size to 128K? - as this size is assigned on the file creation and cannot be changed later - I suppose that you made a backup of your data and then process a full restore.. is it so? Rgds, -Dimitri On 5/8/10, Josh Berkus wrote: