Re: Why copy_relation_data only use wal whenWALarchivingis enabled

Поиск
Список
Период
Сортировка
От Florian G. Pflug
Тема Re: Why copy_relation_data only use wal whenWALarchivingis enabled
Дата
Msg-id 471783EC.9040200@phlo.org
обсуждение исходный текст
Ответ на Re: Why copy_relation_data only use wal whenWALarchivingis enabled  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> "Florian G. Pflug" <fgp@phlo.org> writes:
>> What is the argument against making relfilenodes globally unique by adding
>> the xid and epoch of the creating transaction to the filename?
> 
> 1. Zero chance of ever backpatching.  (I know I said I wasn't excited about
> that, but it's still a strike against a proposed fix.)
> 
> 2. Adds new fields to RelFileNode, which will be a major code change, and
> possibly a noticeable performance hit (bigger hashtable keys).
> 
> 3. Adds new columns to pg_class, which is a real PITA ...
> 
> 4. Breaks oid2name and all similar code that knows about relfilenode.

Ah, Ok. I was under the impression that relfilenode in pg_class is a string of
some kind. In that case only GetNewRelFileNode would have needed patching...
But that is obviously not the case, as I realized now :-(

Thanks for setting me straight ;-)

regards, Florian Pflug


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

Предыдущее
От: Decibel!
Дата:
Сообщение: Re: max_prepared_transactions default ... why 5?
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: ts_rewrite aggregate API seems mighty ugly