Re: FKs on temp tables: hard, or just omitted?

Поиск
Список
Период
Сортировка
От Sander Steffann
Тема Re: FKs on temp tables: hard, or just omitted?
Дата
Msg-id 002001c5dd3d$928d3b40$64c8a8c0@balefirehome
обсуждение исходный текст
Ответ на FKs on temp tables: hard, or just omitted?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: FKs on temp tables: hard, or just omitted?  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: 8.1 Release Candidate 1 Bundled ...
Следующее
От: Robert Treat
Дата:
Сообщение: Re: add_missing_from breaks existing views