Re: [GENERAL] Streaming replication and sharding

2013-02-19 Thread René Romero Benavides
Looking forward to that release and best wishes for the project in general. On Tuesday, February 19, 2013 01:02:34 PM Michael Paquier wrote: On Tue, Feb 19, 2013 at 6:01 AM, René Romero Benavides wrote: There's also one project called Postgres-XC which seems very promising, but I'm kind of w

Re: [GENERAL] Streaming replication and sharding

2013-02-18 Thread Michael Paquier
On Tue, Feb 19, 2013 at 6:01 AM, René Romero Benavides wrote: > ** > > There's also one project called Postgres-XC which seems very promising, > but I'm kind of wary about its level of maturity. > Project page is here: https://sourceforge.net/projects/postgres-xc/ The latest version 1.0 released

Re: [GENERAL] Streaming replication and sharding

2013-02-18 Thread René Romero Benavides
There's also one project called Postgres-XC which seems very promising, but I'm kind of wary about its level of maturity. On Monday, February 18, 2013 08:00:33 AM Albe Laurenz wrote: > Tiemo Kieft wrote: > > > We are developing an application that uses various web analytics packages > > (like Go

Re: [GENERAL] Streaming replication and sharding

2013-02-18 Thread René Romero Benavides
I'm also interested in leveraging something like that, these are my thoughts: - Have a master server with all the data - Have the data partitioned vertically (inheritance, exclusion constrains, etc) - One synchronous slave - N asynchronous slaves that feed from the synchronous slave (cascading r

Re: [GENERAL] Streaming replication and sharding

2013-02-18 Thread Albe Laurenz
Tiemo Kieft wrote: > We are developing an application that uses various web analytics packages > (like Google Analytics) to > run analyses on. We are currently in closed beta stadium where we don't have > a lot of data in the > database, but at some point it will grow considerably. > > We basica

[GENERAL] Streaming replication and sharding

2013-02-17 Thread Tiemo Kieft
Hi, We are developing an application that uses various web analytics packages (like Google Analytics) to run analyses on. We are currently in closed beta stadium where we don't have a lot of data in the database, but at some point it will grow considerably. We basically have two different sets of