[pgpool-general: 546] Re: load balancing seems to be bottlenecked by performance of master

[Matt Solnit]

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.

-- Matt