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
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
