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

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: [HACKERS] PATCH: psql show index with type info
Дата
Msg-id 20170310140022.GE9812@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: [HACKERS] PATCH: psql show index with type info  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
* Robert Haas (robertmhaas@gmail.com) wrote:
> 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.

Fair enough, sounds like a good reason to add an Access Method column to
me.

Thanks!

Stephen

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] WIP: Faster Expression Processing v4
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Re: proposal - psql: possibility to specify sort fordescribe commands, when size is printed