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

From Simon Riggs
Subject Re: Temporary tables under hot standby
Date
Msg-id CA+U5nMKSwJ22qqoub=nYj06ZdX+ZHFQRX2w2J76+NdJtobcKMQ@mail.gmail.com
Whole thread Raw
In response to Re: Temporary tables under hot standby  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Temporary tables under hot standby  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Wed, Apr 25, 2012 at 5:19 PM, Robert Haas <robertmhaas@gmail.com> wrote:

> Oh, we're talking about different things, and I'm slightly confused.
>
> Yes, we need to support ANALYZE; what we might not need to support, at
> least initially, is every user of a global temp table having their own
> SEPARATE copy of the table statistics.

Yes, we are. Global Temp Tables won't solve the "Works on HS" problem,
so we'd better decide fairly quickly which use case we are addressing,
and why. ISTM Global Temp Tables is more an Oracle compatibility issue
than a problem PostgreSQL users have.

...I have zero basis for deciding whether what you say about Global
Temp Tables is useful or not.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Temporary tables under hot standby
Next
From: Tom Lane
Date:
Subject: Re: remove dead ports?