[pgpool-general: 536] Re: load balancing seems to be bottlenecked by performance of master
Lonni J Friedman
netllama at gmail.com
Tue May 29 08:07:49 JST 2012
On Mon, May 28, 2012 at 3:54 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> What are the reasons for analysing system catalogs on primary server?
>
> For example, if a table is a temporary one or not.
Yes, but as I noted, I don't use temp tables at all. If this is the
primary justification, then its not doing me any good, and causing
unnecessary negative performance impact.
I understand if this isn't something you can fix right now, but I'm
not even getting the impression that you consider this to be a design
flaw. A high write volume on the master should never impact the
response time of any standby/slave with a read query. This literally
means that pgpool doesn't scale well in write heavy environments.
More information about the pgpool-general
mailing list