[Pgpool-general] tons of selects to pg_catalog on master

[Martín Marqués]

2011/11/10 Tatsuo Ishii <ishii at sraoss.co.jp>:
>> Why does pgpool execute so many select count(*) on master server,
>> especifically on pg_proc, pg_class and pg_namespace?
>
> For various reasons. For examle, if the target table in your SELECT is
> a tempory one, it should not be redirected to standbys because
> temporary tables never replicated to standbys. To know if the table is
> a tempory table or not, pgpool need to access pg_class.

OK. Good to know.

Thanks Tatsuo!


-- 
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador