[Pgcluster-general] SELECT is executed on all nodes if withing transaction

[Alexey Kamenchuk]

Hi At

Thanks a lot for reply!

Unfortunately I don't control transactions myself - JBoss application server
does this for me. It always uses explicit transaction managements and this
cannot be turned off

Is it possible to change behaviour of PGCluster so that SELECT statements
are sent to single node?

Thanks
Alexey


-----Original Message-----
From: pgcluster-general-bounces at pgfoundry.org
[mailto:pgcluster-general-bounces at pgfoundry.org] On Behalf Of
a.mitani at sra-europe.com
Sent: Monday, February 19, 2007 5:33 PM
To: pgcluster-general at pgfoundry.org
Subject: Re: [Pgcluster-general] 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 at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>

_______________________________________________
Pgcluster-general mailing list
Pgcluster-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgcluster-general