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

From Josh Berkus
Subject Re: Temporary tables under hot standby
Date
Msg-id 4FA2D736.8030108@agliodbs.com
Whole thread Raw
In response to Re: Temporary tables under hot standby  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
> (on standby)
> INSERT INTO s1 <SELECT1>;
> SELECT ... FROM s1 WHERE ...
> which seems to me to be actually harder than just rewriting as derived
> table and isn't an option on Microstrategy etc, hence my observation
> that GTTs don't help HS much. What I would like to see, one day, is
> for temp tables to work without any changes.

100% agreement.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Re: xReader, double-effort (was: Temporary tables under hot standby)
Next
From: Robert Haas
Date:
Subject: Re: CLOG extension