From: James Mansion <james@mansionfamily.plus.com>
To: PFC <lists@peufeu.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: Laszlo Nagy <gandalf@shopzeus.com>
Cc: pgsql-performance@postgresql.org, Tony Nagy <tony@shopzeus.com>
Subject: Re: Planning a new server - help needed
Date: Sat, 29 Mar 2008 16:47:53 +0000
Message-ID: <47EE72B9.1000507@mansionfamily.plus.com> (raw)
In-Reply-To: <op.t8r6d212cigqcu@apollo13.peufeu.com>
References: <47ECB4F6.1040901@shopzeus.com>
<Pine.GSO.4.64.0803281300240.2521@westnet.com>
<47EE1B1F.20506@mansionfamily.plus.com>
<op.t8r6d212cigqcu@apollo13.peufeu.com>
PFC wrote:
>
>> Why do you claim that 'More platters also means slower seeks
>> and generally slower performance.'?
>
> More platters -> more heads -> heavier head assembly -> slower
> seek time
Note sure I've sen a lot of evidence of that in drive specifications!
> Gigabyte should revamp their i-RAM to use ECC RAM of a larger
> capacity... and longer lasting battery backup...
You would think a decent capacitor or rechargable button battery would
be enough to dump it to a flash memory.
No problem with flash wear then.
> I wonder, how many write cycles those Flash drives can take before
> reliability becomes a problem...
Hard to get data isn't it? I believe its hundreds of thousands to
millions now. Now each record in most OLTP
tables is rewritten a few times unless its stuff that can go into temp
tables etc, which should be elsewhere.
Index pages clearly get rewritten often.
I suspect a mix of storage technologies will be handy for some time yet
- WAL on disk, and temp tables on
disk with no synchronous fsync requirement.
I think life is about to get interesting in DBMS storage. All good for
us users.
James
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: james@mansionfamily.plus.com, lists@peufeu.com, gsmith@gregsmith.com, gandalf@shopzeus.com, tony@shopzeus.com
Subject: Re: Planning a new server - help needed
In-Reply-To: <47EE72B9.1000507@mansionfamily.plus.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