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

[Lazaro Rubén García Martinez]

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.

-----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