From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Mohsen Bande <mohsenbande(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Strange Index sizes |
Date: | 2018-04-25 14:38:06 |
Message-ID: | de819c3c-5897-72df-7f17-bd415b0a4bfa@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/24/2018 11:41 PM, Mohsen Bande wrote:
> Hi all,
> I have a user table with ~8M records, with different type of fields
> b-tree indexed.
Could we see table schema and index statements?
> by investigating index sizes, i found two strange things:
> 1- all index sizes are almost the same, regardless of field type
> (boolean, string, bigint)
What was the command you used to determine the sizes?
> 2 - all of them are much bigger that my expectation, e.g. for a boolean
> field, even after reindexing, the size is 217MB, so each record takes
> ~27 bytes.
>
> could some one shed some light on this please? or refer any user
> oriented documentation about index size estimations
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2018-04-25 14:45:47 | Re: Inconsistent compilation error |
Previous Message | raf | 2018-04-25 12:33:11 | Re: Inconsistent compilation error |