Re: Drop type "smgr"?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Drop type "smgr"?
Дата
Msg-id 9762.1551369986@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Drop type "smgr"?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Drop type "smgr"?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> My first intuition was the same as yours -- that we should use the
> tablespace to decide which smgr is relevant -- but I now think that
> intuition was wrong.  Even if you use the tablespace OID to select the
> smgr, it doesn't completely solve the problem you're worried about
> here.  You still have to put SOMETHING in the database OID field, and
> that's going to be just as fake as it was before.

My thought was that that could be zero if not relevant ... isn't that
what we do now for buffer tags for shared rels?

> I guess you could
> use the OID for pg_global for things like undo and SLRU data, but then
> how is GetRelationPath() going to work?  You don't have enough bits
> left anywhere to specify both a tablespace and a location within that
> tablespace in a reasonable way, and I think it's far from obvious how
> you would build a side channel that could carry that information.

It's certainly possible/likely that we're going to end up needing to
widen buffer tags to represent the smgr explicitly, because some use
cases are going to need a real database spec, some are going to need
a real tablespace spec, and some might need both.  Maybe we should
just bite that bullet.

            regards, tom lane


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

Предыдущее
От: Joshua Brindle
Дата:
Сообщение: Re: Re: Row Level Security − leakproof-ness and performance implications
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Add exclusive backup deprecation notes to documentation