From: Craig Ringer <craig@postnewspapers.com.au>
To: Lars <la@unifaun.com>
Cc: mark <dvlhntr@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Migrating to Postgresql and new hardware
Date: Thu, 20 Jan 2011 08:42:58 +0800
Message-ID: <4D378512.3060007@postnewspapers.com.au> (raw)
In-Reply-To: <E0B1224AD40B544B9DE1BCC6008E95220D1F192D74@UF05.unifaun.se>
References: <E0B1224AD40B544B9DE1BCC6008E95220D1F192CC2@UF05.unifaun.se>
<006601cbb78e$b1c26fe0$15474fa0$@com>
<E0B1224AD40B544B9DE1BCC6008E95220D1F192D74@UF05.unifaun.se>
On 01/19/2011 05:09 PM, Lars wrote:
> Thanks for the reply!
>
> MyISAM was chosen back in 2000. I'm not aware of the reasoning behind this choice...
>
> Dell claims both the Samsung and the Pliant are safe to use.
> Below is a quote from the Pliant datasheet:
> "No Write Cache:
> Pliant EFDs deliver outstanding
> write performance
> without any dependence on
> write cache and thus does
> not use battery/supercap."
Er ... magic? I wouldn't trust them without details on *how* it achieves
good performance, and what "good" is.
Is there *any* device on the market that efficiently handles lots of
small writes?
>
>> As others have mentioned, how are you going to be doing your "shards"?
> Hmm... shards might not have been a good word to describe it. I'll paste what I wrote in another reply:
> I used sharding as an expression for partitioning data into several databases.
"sharding" or "shards" is pretty much the standard way that setup is
described. It doesn't come up on the Pg list a lot as most people doing
web-oriented horizontally scaled apps use MySQL or fashionable non-SQL
databases, but it's pretty well known in wider circles.
--
Craig Ringer
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: craig@postnewspapers.com.au, la@unifaun.com, dvlhntr@gmail.com
Subject: Re: Migrating to Postgresql and new hardware
In-Reply-To: <4D378512.3060007@postnewspapers.com.au>
* 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