Re: SELECT is executed on all nodes if withing transaction

Hi,

Any queries within transaction may send each cluster DB as replication.
When you want to send a SELECT query to single node, please send it
without transaction query.

Regards,
------------------
At.Mitani


> I mentioned that load balancer executes SELECT on all nodes if it is
> issued
> within transaction. I expected the behavior when SELECT is sent to only DB
> node. Is it something wrong with my configuration or this is how LB always
> works?
>
>
>
> Thanks
>
>
>
> Best regards
>
> Alexey Kamenchuk
>
>
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general@xxxxxxxxxxxxx
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>