Postgres Pro
Downloads
Home   >   mailing lists

Index size - Mailing list pgsql-general

From Samuel Williams
Subject Index size
Date
Msg-id CAHkN8V8gLCfwdobKWxFfMmFaFBSzbryPzBVvnvjXvg-kBsS1yQ@mail.gmail.com
Whole thread Raw
Responses Re: Index size  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
I'd like to understand a bit more about indexes in PG.

When I have a row in a table, and an index, say, for a single column,
does that duplicate the entire row on disk? Or is there some kind of
id lookup involved?

Thanks.

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: How to migrate from PGSQL 9.3 to 9.6
Next
From: Patrick B
Date:
Subject: Monitoring Replication - Postgres 9.2