On 24/08/11 15:15, Tom Lane wrote:
Hmmm ... this is structurally a pretty simple query, so I'm surprised
that 8.3 and 8.4 see it very much differently. The relation-level
estimates and plan choices are very nearly the same; the only thing
that's changed much is the estimates of the join sizes,
On 24/08/11 15:15, Tom Lane wrote:
Mark Kirkwood writes:
I am in the progress of an 8.3 to 8.4 upgrade for a customer. I seem to
have stumbled upon what looks like a regression. The two databases
(8.3.14 and 8.4.8) have identical tuning parameters (where that makes
sense) and run on identical h
On 08/23/2011 06:42 PM, David Boreham wrote:
I took a look at Areca. The fan on the controller board is a big
warning signal for me (those fans are in my experience the single most
unreliable component ever used in computers).
I have one of their really early/cheap models here, purchased in ear
Mark Kirkwood writes:
> I am in the progress of an 8.3 to 8.4 upgrade for a customer. I seem to
> have stumbled upon what looks like a regression. The two databases
> (8.3.14 and 8.4.8) have identical tuning parameters (where that makes
> sense) and run on identical hardware. Both databases are
On Tue, Aug 23, 2011 at 4:42 PM, David Boreham wrote:
> On 8/22/2011 10:55 PM, Scott Marlowe wrote:
>>
>> If you're running linux and thus stuck with the command line on the
>> LSI, I'd recommend anything else. MegaRAID is the hardest RAID
>> control software to use I've ever seen. If you can sp
On 8/22/2011 10:55 PM, Scott Marlowe wrote:
If you're running linux and thus stuck with the command line on the
LSI, I'd recommend anything else. MegaRAID is the hardest RAID
control software to use I've ever seen. If you can spring for the
money, get the Areca 1680:
http://www.newegg.com/Produ
On August 22, 2011 09:55:33 PM Scott Marlowe wrote:
>
> If you're running linux and thus stuck with the command line on the
> LSI, I'd recommend anything else. MegaRAID is the hardest RAID
> control software to use I've ever seen. If you can spring for the
> money, get the Areca 1680:
> http://ww
On 8/23/2011 5:14 AM, Robert Schnabel wrote:
I'm by no means an expert but it seems to me if you're going to choose
between two 6 GB/s cards you may as well put SAS2 drives in. I have
two Adaptec 6445 cards in one of my boxes and several other Adaptec
series 5 controllers in others. They su
On 8/22/2011 9:42 PM, David Boreham wrote:
I'm buying a bunch of new machines (all will run an application that heavily
writes to PG). These machines will have 2 spindle groups in a RAID-1 config.
Drives will be either 15K SAS, or 10K SATA (I haven't decided if it is
better
to buy the faster dri
