Re: FKs on temp tables: hard, or just omitted? - Mailing list pgsql-hackers

From Sander Steffann
Subject Re: FKs on temp tables: hard, or just omitted?
Date
Msg-id 002001c5dd3d$928d3b40$64c8a8c0@balefirehome
Whole thread Raw
In response to FKs on temp tables: hard, or just omitted?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: FKs on temp tables: hard, or just omitted?
List pgsql-hackers
Hi,

> Martijn van Oosterhout <kleptog@svana.org> writes:
>> You solve it by allowing other backends to lock and examine your
>> temporary tables. But AIUI temporary tables are not stored in shared
>> memory so how do you get a consistant view of it?
>
>> Not unsolvable, but very tricky.
>
> Right, the problem isn't that "it can't be done", it's that "it can't be
> done without giving up most of the performance advantages of temp tables".
> Which seems like a bad tradeoff, at least to me ...

Ah, now I understand the problem :-)

And I think you are right. It would be a very bad tradeoff.
Sander




pgsql-hackers by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: 8.1 Release Candidate 1 Bundled ...
Next
From: Robert Treat
Date:
Subject: Re: add_missing_from breaks existing views