Re: [HACKERS] PATCH: psql show index with type info

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [HACKERS] PATCH: psql show index with type info
Дата
Msg-id CA+TgmoZTG1xOMcm1HorHhsSmJEfDB_Z4oz8M8RhiZzOe=csyJw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] PATCH: psql show index with type info  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: [HACKERS] PATCH: psql show index with type info  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-hackers
On Mon, Mar 6, 2017 at 9:30 AM, Stephen Frost <sfrost@snowman.net> wrote:
> * Amos Bird (amosbird@gmail.com) wrote:
>> Well, the prefix is used to differentiate other \d commands, like
>> this,
>
> Ah, ok, fair enough.
>
> Should we consider differentiating different table types also?  I
> suppose those are primairly just logged and unlogged, but I could see
> that being useful information to know when doing a \dt.  Not a big deal
> either way though, and this patch stands on its own certainly.

Logged vs. unlogged isn't the same thing as identifying the access
method.  Anything with storage can come in logged, unlogged, and
temporary varieties, but an access method is essentially a way of
saying that one object has a different physical layout than another.
Right now there is, indeed, only one heap access method, but some of
my colleagues and I are scheming over how to change that.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: [HACKERS] GSOC Introduction / Eliminate O(N^2) scaling fromrw-conflict tracking in serializable transactions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Bizarre choice of case for RELKIND_PARTITIONED_TABLE