From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org, heikki(dot)linnakangas(at)enterprisedb(dot)com |
Subject: | Re: Summary and Plan for Hot Standby |
Date: | 2009-11-16 07:59:22 |
Message-ID: | 1258358362.14054.4406.camel@ebony |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2009-11-16 08:02:54 | Re: Patch committers |
Previous Message | Magnus Hagander | 2009-11-16 07:44:05 | Re: [HACKERS] pgsql: /home/peter/commit-msg |