Re: Summary and Plan for Hot Standby

On Mon, 2009-11-16 at 13:23 +0900, Tatsuo Ishii wrote:
> Just a question:
> 
> - Does Hot Standby allow to use prepared query (not prepared
>   transaction) in standby? I mean: Parse message from frontend can be
>   accepted by standby?

Yes, no problem with any of those kind of facilities

> - Can we create tempory tables in standby?

No, but this is for two reasons

* CREATE TEMPORARY TABLE actually writes to catalog tables. It doesn't
need to do that, so allowing this would require some medium-heavy
lifting of the way temp tables work. A preliminary design was agreed in
July 2008. I believe it would be a popular feature, since about 40-50%
of people ask for this.

* CREATE TEMP TABLE is currently considered to be disallowed during read
only transactions. That might be able to change if the underlying
physical operation were write-free.

-- Simon Riggs           www.2ndQuadrant.com