to 0. Unfortunately this would not help
> on a query by query basis, but the above would.
>
>
>
>
>
>
>
>
>
>
>
>
>
> -Original Message-
> From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 23, 2005 7:23 PM
> To: Brian Magui
> On Sun, 2005-04-24 at 00:53, Ron Mayer wrote:
> > Tatsuo Ishii wrote:
> > >>
> > >>Is there anyway to load balance selects to more than 2 servers? ex. 1
> > >>master with 2 slaves? Run multiple instances?
> > >
> > > It's on my TODO but will not be a trivial change.
> >
> > Could I set up 2
PM
To: Brian Maguire
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Pgpool questions
> I have a couple Pgpool questions regarding running pgpool as a
load balancer with Sony as the replicator.
>
>
>
> Is there anyway to load balance selects to more than 2 servers
On Sun, 2005-04-24 at 00:53, Ron Mayer wrote:
> Tatsuo Ishii wrote:
> >>
> >>Is there anyway to load balance selects to more than 2 servers? ex. 1
> >>master with 2 slaves? Run multiple instances?
> >
> > It's on my TODO but will not be a trivial change.
>
> Could I set up 2 pairs of pgpool-ba
Tatsuo Ishii wrote:
Is there anyway to load balance selects to more than 2 servers? ex. 1 master with 2 slaves? Run multiple instances?
It's on my TODO but will not be a trivial change.
Could I set up 2 pairs of pgpool-balanced servers, and use a
third pgpool to load balance across the two pools?
> I have a couple Pgpool questions regarding running pgpool as a load balancer
> with Sony as the replicator.
>
>
>
> Is there anyway to load balance selects to more than 2 servers? ex. 1 master
> with 2 slaves? Run multiple instances?
It's on my TODO but will not be a trivial change.
> I
On Sat, Apr 23, 2005 at 08:37:02AM -0700, Joshua D. Drake wrote:
> Brian Maguire wrote:
> >Is there any way to tell a select query to only go to the slave?
>
> That i don't know.
I think Tatsuo said recently that it was an interesting suggestion and
the he'd look into implementing it.
--
Alv
Brian Maguire wrote:
I have a couple Pgpool questions regarding running pgpool as a load balancer
with Sony as the replicator.
Is there anyway to load balance selects to more than 2 servers? ex. 1 master with 2 slaves? Run multiple instances?
My understanding is that if you turn on the load b
