From: Md. Ezhar Ansari <ezhar.ansari@alumnux.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Inquiry Regarding PostgreSQL Index Size - Seeking Community Insights
Date: Fri, 22 Dec 2023 14:20:22 +0000
Message-ID: <BM1PR01MB371413CB7A7DC039C8892ECB8F94A@BM1PR01MB3714.INDPRD01.PROD.OUTLOOK.COM> (raw)
Hi Folks,
I recently posted a question on the Database Administrators Stack Exchange platform<https://dba.stackexchange.com/; that I believe aligns with the expertise of your community. The question revolves around the size difference between a composite index and a default index on the 'ID' column. The link to the question is provided below:
Why the size of composite index is less than the default index (index on ID)?<https://dba.stackexchange.com/questions/334284/why-the-size-of-composite-index-is-less-than-the-defa...;
I am eager to hear any thoughts or explanations you might have regarding this observed size difference. Have you encountered similar scenarios, and do you have any recommendations or explanations for this phenomenon?
Ezhar
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ezhar.ansari@alumnux.com, pgsql-admin@lists.postgresql.org
Subject: Re: Inquiry Regarding PostgreSQL Index Size - Seeking Community Insights
In-Reply-To: <BM1PR01MB371413CB7A7DC039C8892ECB8F94A@BM1PR01MB3714.INDPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox