Re: Temporary tables under hot standby

Michael Nolan <htfoot@gmail.com>

From: Michael Nolan <htfoot@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Simon Riggs <simon@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, Noah Misch <noah@leadboat.com>, pgsql-hackers@postgresql.org
Date: 2012-05-02T15:39:21Z
Lists: pgsql-hackers
What is the use case for temporary tables on a hot standby server?

Perhaps this is a noobie question, but it seems to me that a hot standby
server's use by* applications* or *users* should be limited to transactions
that don't alter the database in any form.

However, I can see where temporary tables might be needed at the system
level (if not already available) in order to prepare more efficient plans
for some complex read-only queries.
--
Mike Nolan