Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL clustering VS MySQL clustering

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: 2005-02-18 23:20:08
Message-ID: cv5t83$1njl$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-performance
Josh Berkus wrote:
> Tatsuo,
> 
> 
>>Yes. However it would be pretty easy to modify pgpool so that it could
>>cope with Slony-I. I.e.
>>
>>1) pgpool does the load balance and sends query to Slony-I's slave and
>>   master if the query is SELECT.
>>
>>2) pgpool sends query only to the master if the query is other than
>>   SELECT.

Don't you think that this is unsafe ?


SELECT foo(id), id
FROM bar;


where foo have side effect.

Is pgpool able to detect it and perform this select on the master ?


Regards
Gaetano Mendola




In response to

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2005-02-18 23:27:07
Subject: Re: PostgreSQL clustering VS MySQL clustering
Previous:From: Rodrigo MorenoDate: 2005-02-18 16:10:01
Subject: RES: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group