Create temporary table in replica instances issues

Поиск
Список
Период
Сортировка
От Saravanan Shanmugam
Тема Create temporary table in replica instances issues
Дата
Msg-id CAB5b++UTpZ=5q9yTZj+KpOyH-CuLT2=p_PpyQC3zTmY=xh5N8w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Create temporary table in replica instances issues  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Create temporary table in replica instances issues  (Saravanan Shanmugam <saravanantvr1984@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
Hello, 

We have AWS RDS with Primary and replica node to balance IO RW for application performance, 

In such cases we will be livergaing all read related queries to replica nodes, 
sometimes we will create temp tables not physical tables and do some complicated queries .  

PG SQL replica node throws Create table not allowed in reader-instance 
But this not Physical table its temporary table, in MS-SQL and MYSQL are supporting, Why Pgsql is not supporting?? 

Please do we have this option to enable or is this a bug??



--
Many thanks,
Saravanan Shanmugam
Mobile : +918939939234

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: BUG #16754: When using LLVM and parallel queries aborted all session by pg_cancel_backend.
Следующее
От: Saravanan Shanmugam
Дата:
Сообщение: Re: Create temporary table in replica instances issues