Re: [HACKERS] PATCH: psql show index with type info - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [HACKERS] PATCH: psql show index with type info
Date
Msg-id 20170310140022.GE9812@tamriel.snowman.net
Whole thread Raw
In response to Re: [HACKERS] PATCH: psql show index with type info  (Robert Haas <robertmhaas@gmail.com>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] WIP: Faster Expression Processing v4
Next
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Re: proposal - psql: possibility to specify sort fordescribe commands, when size is printed