On Mon, Mar 4, 2013 at 1:01 PM, Daniel de Oliveira Mantovani <
daniel.oliveira.mantov...@gmail.com> wrote:
> just fixing:
>
> like Netezza which has full implementation to do it.*
>
> On 4 March 2013 14:59, Daniel de Oliveira Mantovani
> wrote:
> > One question about Postgres-XC, can it distribut
just fixing:
like Netezza which has full implementation to do it.*
On 4 March 2013 14:59, Daniel de Oliveira Mantovani
wrote:
> One question about Postgres-XC, can it distribute one single query in
> all nodes ?
>
> Example,
> Nodes: Node1,Node2,Node3
> Query:"SELECT sum(foo) FROM bar group by f
One question about Postgres-XC, can it distribute one single query in
all nodes ?
Example,
Nodes: Node1,Node2,Node3
Query:"SELECT sum(foo) FROM bar group by foo"
(Obvious: Your data has to be shared between the nodes)
Query -> Compiler (in the pool)-> "share the query between the nodes"
-> merge
Version 1.1 will be out in this June time frame, with online node
addition/removal, Trigger and improved planner. I'm more than happy
if you evaluate XC.
Regards;
--
Koichi Suzuki
2013/3/4 Greg Jaskiewicz :
>
> On 4 Mar 2013, at 13:21, Vincent Veyron wrote:
>
>>
>> There is this :
>>
>
On 4 Mar 2013, at 13:21, Vincent Veyron wrote:
>
> There is this :
>
> http://wiki.postgresql.org/wiki/Postgres-XC
>
>
> [Disclaimer : I can't tell whether it's usable or not; I just know they
> exist]
>
Well, I know of its existence too. Question is how production ready is it. And
also
Le dimanche 03 mars 2013 à 23:29 +, Gregg Jaskiewicz a écrit :
>
>
> I wonder however, how others are handing it. There seems to be nothing
> out there apart from pgbouncer and pgpool. And only the latter can
> handle (albeit not really that quick) pooling between master and
> slaves.
>
>
On 3 March 2013 22:56, John R Pierce wrote:
>
> did you look at pgbouncer ? thats the simple pooler for postgres, and its
> quite robust, because its so simple.
>
>
Yes, it is one of the solutions I do consider. Having applications decide
whether they should write to master, or use slaves and/or
On 3/3/2013 1:57 PM, Gregg Jaskiewicz wrote:
I don't know of any other pooling solution that would be capable of
handling the job, but focus only on the task of pooling (pgpool's
fault probably is that it is trying to be jack of all trades) in HA
replicated scenario.
did you look at pgbounc
Hi guys,
I'm looking into setting up an HA scalable DB cluster.
So far my tests with streaming replication proof that it is very very good
indeed.
However, problem seems to be on the connection pooling side. Ideally, we
would love to have single point of connection to the cluster, but I do
realis
