Re: horizontal sharding - Mailing list pgsql-general

From David Fetter
Subject Re: horizontal sharding
Date
Msg-id 20090615150730.GD20647@fetter.org
Whole thread Raw
In response to horizontal sharding  (mobiledreamers@gmail.com)
Responses Re: horizontal sharding
List pgsql-general
On Mon, Jun 15, 2009 at 12:32:15AM -0700, mobiledreamers@gmail.com wrote:
> Hey guys
> what is a good way to horizontal shard in postgresql

"Sharding" is not really a technical term, so it's not really possible
to answer this question meaningfully as posed.

What is it that you actually want to accomplish here exactly?  What
are your goals, and what are your priorities on those goals?  What
will you trade off to achieve them?

> 1. pgpool 2
> 2. gridsql
>
> which is a better way to use sharding
>
> also is it possible to paritition without changing client code

Almost certainly not.  This would be one of the trade-offs mentioned
above.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Custom Fields Database Architecture
Next
From: Vick Khera
Date:
Subject: Re: Trigger Function and backup