From: Chris Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Making the most of memory?
Date: Thu, 24 Jan 2008 11:09:08 -0500
Message-ID: <60ve5jkxy3.fsf@dba2.int.libertyrms.com> (raw)
References: <4796BE84.9030803@centriccrm.com>
<dcc563d10801222120q78e390dbj2b884eca729c2975@mail.gmail.com>
<B30794E6-CD2A-43C1-B431-E24B56FBFB1D@concursive.com>
<dcc563d10801231044p1dba892r9b8bf1269395f068@mail.gmail.com>
<47979C15.3040406@burntmail.com>
<dcc563d10801231745j449fd840kd2d822d358e59d96@mail.gmail.com>
scott.marlowe@gmail.com ("Scott Marlowe") writes:
> On Jan 23, 2008 1:57 PM, Guy Rouillier <guyr-ml1@burntmail.com> wrote:
>> Scott Marlowe wrote:
>> > I assume you're talking about solid state drives? They have their
>> > uses, but for most use cases, having plenty of RAM in your server will
>> > be a better way to spend your money. For certain high throughput,
>> > relatively small databases (i.e. transactional work) the SSD can be
>> > quite useful.
>>
>> Unless somebody has changes some physics recently, I'm not understanding
>> the recent discussions of SSD in the general press. Flash has a limited
>> number of writes before it becomes unreliable. On good quality consumer
>
> Actually, I was referring to all SSD systems, some of which are based
> on flash memory, some on DRAM, sometimes backed by hard drives.
>
> There's always a use case for a given piece of tech.
Yeah, I could see an SSD making use of a mixture of technologies...
- Obviously, it needs a pile of RAM.
- Then, have a battery that can keep the RAM backed up for [a while].
- If power goes out, then contents of RAM get copied out to the "flash"
memory.
In this context, "flash" has several merits over disk drives.
Notably, the absence of moving mechanical parts means:
- Hopefully lower power consumption than a disk drive
- Less fragility than a disk drive
- Quite likely the "flash" will be smaller than a disk drive
The fact that the number of writes may be limited should only be an
important factor if power goes out *INCREDIBLY* frequently, as data
only gets written upon power loss.
The combination of RAM + battery + flash looks like a real winner,
when they are combined using a protocol that takes advantage of their
strengths, and which doesn't rest on their weaknesses.
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/advocacy.html
Roses are red
Violets are blue
Some poems rhyme
But this one doesn't.
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: cbbrowne@acm.org
Subject: Re: Making the most of memory?
In-Reply-To: <60ve5jkxy3.fsf@dba2.int.libertyrms.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