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.
In response to
pgsql-hackers by date
|Next:||From: Christopher Browne||Date: 2012-05-02 15:53:58|
|Subject: Re: Temporary tables under hot standby|
|Previous:||From: Peter Geoghegan||Date: 2012-05-02 15:35:52|
|Subject: Latch for the WAL writer - further reducing idle wake-ups.|