Postgres Pro
Downloads
Home   >   mailing lists

Thread: data partitions across different nodes

data partitions across different nodes

From
"金星星"
Date:
Are there any solutions based on PostgreSQL that can support
distributing partitions (horizontal fragmentations) across different
nodes. It doesn't need to support distributed transaction, since data
inconsistent is not a critical problem in my situation.

Re: data partitions across different nodes

From
"Mikko Partio"
Date:


On 6/26/07, 金星星 <james.king.zj@gmail.com> wrote:
Are there any solutions based on PostgreSQL that can support
distributing partitions (horizontal fragmentations) across different
nodes. It doesn't need to support distributed transaction, since data
inconsistent is not a critical problem in my situation.


pgpool-II might be what you're looking for.

http://pgpool.projects.postgresql.org/pgpool-II/en/

Regards

MP


Re: data partitions across different nodes

From
"hubert depesz lubaczewski"
Date:
On 6/26/07, 金星星 <james.king.zj@gmail.com> wrote:
Are there any solutions based on PostgreSQL that can support
distributing partitions (horizontal fragmentations) across different
nodes. It doesn't need to support distributed transaction, since data
inconsistent is not a critical problem in my situation.

look at skype tools, to be specific - pl/proxy was made to make this kind of things possible.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz