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

From Robert Haas
Subject Re: [HACKERS] PATCH: psql show index with type info
Date
Msg-id CA+TgmoZTG1xOMcm1HorHhsSmJEfDB_Z4oz8M8RhiZzOe=csyJw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] PATCH: psql show index with type info  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [HACKERS] PATCH: psql show index with type info  (Stephen Frost <sfrost@snowman.net>)
List 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 by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [HACKERS] GSOC Introduction / Eliminate O(N^2) scaling fromrw-conflict tracking in serializable transactions
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Bizarre choice of case for RELKIND_PARTITIONED_TABLE