Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0340F1337B64 for ; Wed, 19 Jan 2011 20:43:17 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 78787-07 for ; Thu, 20 Jan 2011 00:43:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from www.postnewspapers.com.au (www.postnewspapers.com.au [173.230.139.50]) by mail.postgresql.org (Postfix) with ESMTP id E71F61337B5C for ; Wed, 19 Jan 2011 20:43:09 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by www.postnewspapers.com.au (Postfix) with ESMTP id DB2CF14A4; Wed, 19 Jan 2011 19:43:09 -0500 (EST) X-Virus-Scanned: amavisd-new at postnewspapers.com.au.com Received: from www.postnewspapers.com.au ([127.0.0.1]) by localhost (www.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id qrtB41qCvjyi; Wed, 19 Jan 2011 19:43:09 -0500 (EST) Received: from mail.postnewspapers.com.au (ppp171-128.static.internode.on.net [150.101.171.128]) by www.postnewspapers.com.au (Postfix) with ESMTP id DC5A119; Wed, 19 Jan 2011 19:43:08 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 9BC74AEAFC; Thu, 20 Jan 2011 08:43:07 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id Q9rpVWkjpR2i; Thu, 20 Jan 2011 08:43:01 +0800 (WST) Received: from [10.1.1.5] (124-169-36-170.dyn.iinet.net.au [124.169.36.170]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id ABB20AF193; Thu, 20 Jan 2011 08:43:00 +0800 (WST) Message-ID: <4D378512.3060007@postnewspapers.com.au> Date: Thu, 20 Jan 2011 08:42:58 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.13) Gecko/20101209 Fedora/3.1.7-0.35.b3pre.fc14 Thunderbird/3.1.7 MIME-Version: 1.0 To: Lars CC: mark , "pgsql-performance@postgresql.org" Subject: Re: Migrating to Postgresql and new hardware References: <006601cbb78e$b1c26fe0$15474fa0$@com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/178 X-Sequence-Number: 41965 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