From: Andy Colson <andy@squeakycode.net>
To: Craig Ringer <craig@postnewspapers.com.au>
Cc: 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:48:53 -0600
Message-ID: <4D384B55.2020803@squeakycode.net> (raw)
In-Reply-To: <4D378512.3060007@postnewspapers.com.au>
References: <E0B1224AD40B544B9DE1BCC6008E95220D1F192CC2@UF05.unifaun.se>
<006601cbb78e$b1c26fe0$15474fa0$@com>
<E0B1224AD40B544B9DE1BCC6008E95220D1F192D74@UF05.unifaun.se>
<4D378512.3060007@postnewspapers.com.au>
On 1/19/2011 6:42 PM, Craig Ringer wrote:
> On 01/19/2011 05:09 PM, Lars wrote:
>> Thanks for the reply!
>>
>>
>>> 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
>
Or... PG is just so good we've never had to use more than one database
server! :-)
-Andy
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: andy@squeakycode.net, craig@postnewspapers.com.au, la@unifaun.com, dvlhntr@gmail.com
Subject: Re: Migrating to Postgresql and new hardware
In-Reply-To: <4D384B55.2020803@squeakycode.net>
* 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