Re: Temporary tables under hot standby - Mailing list pgsql-hackers

From Michael Nolan
Subject Re: Temporary tables under hot standby
Date
Msg-id CAOzAquLTBE_a2aRn-Cwsdiv_augWEhcCcPzbgqaBB8yO0oOYsQ@mail.gmail.com
Whole thread Raw
In response to Re: Temporary tables under hot standby  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Temporary tables under hot standby
Re: Temporary tables under hot standby
List pgsql-hackers
What is the use case for temporary tables on a hot standby server?<br /><br />Perhaps this is a noobie question, but it
seemsto me that a hot standby server's use by<b> applications</b> or <b>users</b> should be limited to transactions
thatdon't alter the database in any form.<br /><br />However, I can see where temporary tables might be needed at the
systemlevel (if not already available) in order to prepare more efficient plans for some complex read-only queries.<br
/>--<br/>Mike Nolan<br /> 

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Latch for the WAL writer - further reducing idle wake-ups.
Next
From: Christopher Browne
Date:
Subject: Re: Temporary tables under hot standby