[pgpool-general: 68] Re: Pgpool + streaming replication

[Tatsuo Ishii]

> Tatsuo, about this:
> 
>>> "In master/slave mode, SELECTs to temporary table executes only on 
>>> master/primary"
> 
> How pgpool knows that the tables involved in a select, are temporary tables?
> 
> Regards.

Pgpool parses SQL statement to look for table name. Then it issues a
query against PostgreSQL system catalog to know if it is a tempory
table. This works with not only SELECT top level, but with subqueries.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> -----Mensaje original-----
> De: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] En nombre de Tatsuo Ishii
> Enviado el: jueves, 08 de diciembre de 2011 09:38
> Para: forall at stalowka.info
> CC: pgpool-general at pgpool.net
> Asunto: [pgpool-general: 65] Re: Pgpool + streaming replication
> 
>> W dniu 08.12.2011 12:54, Sandeep Thakkar pisze:
>>> According to the docs
>>> (http://pgpool.projects.postgresql.org/NEWS.txt),
>>> "In master/slave mode, SELECTs to temporary table executes only on
>>> master/primary"
>>>
>>>
>> I have a pgpool 3.1 but this features is available in 3.0 pgpool, so
>> why isn't work?
>> One of our programmers said "90% query using temporary tables".
>> So this is pgpool problem wheter our query application?
> 
> Are you sure that your application queries are going through pgpool?
> i.e. you should not directly connect to PostgreSQL standbys.
> --
> 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 at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general