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

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Creation of temporary tables on read-only standby servers
Дата
Msg-id AANLkTi=9=7XBznNrwFYYKY=cEXUqXYmJO0LYMrZv2-9o@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Creation of temporary tables on read-only standby servers  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Creation of temporary tables on read-only standby servers  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Creation of temporary tables on read-only standby servers  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Creation of temporary tables on read-only standby servers  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Tue, Oct 19, 2010 at 12:03 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> The trick is that it would require us to have two pg_class tables, two
> pg_attribute tables, two pg_attrdef tables, etc.: in each case, one
> permanent and one temporary.  I am not sure how complex that will turn
> out to be.

Tom suggested using inheritance for this.

I find it strange to try constructing catalog tables to represent
these local definitions which never need to be read by any other
backend and in any case are 1:1 copies of the global catalog entries.

It seems to me simpler and more direct to just nail relcache
entries for these objects into memory and manipulate them directly.
They can be constructed from the global catalog tables and then
tweaked to point to the backend local temporary tables.


--
greg


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: max_wal_senders must die
Следующее
От: Marios Vodas
Дата:
Сообщение: Re: gist DatumGetPointer returns pointer to corrupted data