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