From: Dave Cramer <pg@fastcrypt.com>
To: Alex Turner <armtuk@gmail.com>
Cc: David Boreham <david_list@boreham.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Hardware/OS recommendations for large databases (
Date: Fri, 18 Nov 2005 07:58:43 -0500
Message-ID: <012EB91C-667A-495F-B4F2-F14EE7162ABA@fastcrypt.com> (raw)
In-Reply-To: <33c6269f0511171150j24f2dd2bq607b69994338aa9@mail.gmail.com>
References: <200511161550.jAGFoCY09049@candle.pha.pa.us>
<437B578C.4000309@boreham.org>
<33c6269f0511171150j24f2dd2bq607b69994338aa9@mail.gmail.com>
On 17-Nov-05, at 2:50 PM, Alex Turner wrote:
> Just pick up a SCSI drive and a consumer ATA drive.
>
> Feel their weight.
>
> You don't have to look inside to tell the difference.
At one point stereo manufacturers put weights in the case just to
make them heavier.
The older ones weighed more and the consumer liked heavy stereos.
Be careful what you measure.
Dave
>
> Alex
>
> On 11/16/05, David Boreham <david_list@boreham.org> wrote:
>>
>>
>> I suggest you read this on the difference between enterprise/SCSI
>> and
>> desktop/IDE drives:
>>
>> http://www.seagate.com/content/docs/pdf/whitepaper/
>> D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf
>>
>>
>> This is exactly the kind of vendor propaganda I was talking about
>> and it proves my point quite well : that there's nothing specific
>> relating
>> to reliability that is different between SCSI and SATA drives
>> cited in that
>> paper.
>> It does have a bunch of FUD such as 'oh yeah we do a lot more
>> drive characterization during manufacturing'.
>>
>>
>>
>>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pg@fastcrypt.com, armtuk@gmail.com, david_list@boreham.org
Subject: Re: Hardware/OS recommendations for large databases (
In-Reply-To: <012EB91C-667A-495F-B4F2-F14EE7162ABA@fastcrypt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox