> 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. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general
