2011/11/10 Tatsuo Ishii <[email protected]>: >> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
