Re: Creation of temporary tables on read-only standby servers

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Creation of temporary tables on read-only standby servers
Дата
Msg-id 24228.1287429998@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Creation of temporary tables on read-only standby servers  (Andres Freund <andres@anarazel.de>)
Ответы Re: Creation of temporary tables on read-only standby servers  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On Monday 18 October 2010 20:06:01 Tom Lane wrote:
>> Not unless you have some credible concept for how it might ever be
>> implemented.  You can't create temp tables because you can't modify
>> system catalogs, and if you did somehow create them you couldn't put
>> anything in them because you can't generate XIDs on a slave ... much
>> less commit them.  We have talked about ways that temp tables might be
>> created without touching the "real" system catalogs, but the XID issue
>> seems a complete showstopper.

> Hm. Wouldnt it be possible to use virtual xids for that purpose? They are 
> never seen outside of that session anyway...

Well, maybe, but then you need infrastructure to track whether VXIDs
committed or aborted.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: create tablespace fails silently, or succeeds improperly
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Floating-point timestamps versus Range Types