[pgpool-general: 546] Re: load balancing seems to be bottlenecked by performance of master
msolnit at soasta.com
Tue May 29 14:28:23 JST 2012
On May 28, 2012, at 6:53 PM, Lonni J Friedman <netllama at gmail.com> wrote:
> On Mon, May 28, 2012 at 5:23 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>>> 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.
>> But how does pgpool know that you are not going to use temporary
>> tables beforehand?
> Provide a new pgpool.conf option that tells it to ignore them (with
> the assumption that they do not exist).
+1 for new pgpool.conf setting, although I think the default should be the
current behavior, for backward compatibility.
Maybe something like "enable_temp_tables", although that might be too
vague. "on" means current behavior, all system catalog queries go to the
master. "off" means that system catalog queries are load-balanced just
like any other.
More information about the pgpool-general