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
Thread-Topic: Inquiry Regarding PostgreSQL Index Size - Seeking Community
 Insights
Thread-Index: AQHaNOEwG6WxAPJl3U+y/8UTwn/95A==
Date: Fri, 22 Dec 2023 14:20:22 +0000
Message-ID: 
 <BM1PR01MB371413CB7A7DC039C8892ECB8F94A@BM1PR01MB3714.INDPRD01.PROD.OUTLOOK.COM>
Accept-Language: en-US
Content-Language: en-US
msip_labels: 
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=alumnux.com;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: BM1PR01MB3714:EE_|MA0PR01MB7236:EE_
x-ms-office365-filtering-correlation-id: 061085d1-6580-4fa9-b33c-08dc02f9228a
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 rzm3nFyFNJB90Oqxl+ibD7VjgszoDsfVhN6Ne6YxaomuSbIQ/9y1xDEKDQOpEKChP+36BtPmU05JbCNBUCxWv/9T/fWuH/birjUdYTxJOlF6JN0UTpGwdGA54fHrmmvgFKAHAuQ8t10Sto9WQ9EuQSJBFoqozMRN5T2jB3v4kX0ayUa1Zs/Hm6Bb/WFci1lOAjop4kA7xQSsPNlMdDxuIusMM+X3VyYvsV/CU9A252MpSZv3+EgU1CgLRBT/hcGjyVpj+C2pjutSjp7gSOEMf79h+zhc4AVD+/A/GBkHlvY2D0U94mSXQ1tfCbNP8OBVCic08x6ZzqeAmUKgxTKpDMEbppNcbKkwlmxm5YsiBj8ZSRW9tnMV9msT7rYJwz9Z46wY1hTHM25U5x95JDt96se00Lc+Y4e/X1jTNxXX1uOEs4BWl6q6HCHFMR+0eccdocELg4m3pw2Y/uGnDH3sBCBv8u23/WzdTVrixXY940D5qsnaLqWXKXpTBEUv37lPlvGXy4Je7bVQNCtHNPJgmSERCqix+fyFvabWFoSH9/3lJt3UvRv1omxHzGGD9QphZiMLujtB5yrcIRQJXdTtxBoVPhEpFPCW/PsaB54vjxGdLbRzuoI/hACjtxTvCKF/
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:BM1PR01MB3714.INDPRD01.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230031)(396003)(366004)(136003)(346002)(39840400004)(376002)(230922051799003)(1800799012)(186009)(64100799003)(451199024)(9686003)(26005)(7696005)(6506007)(71200400001)(41300700001)(122000001)(64756008)(66446008)(66946007)(8936002)(8676002)(83380400001)(52536014)(76116006)(2906002)(6916009)(478600001)(316002)(5660300002)(4744005)(66556008)(1015004)(66476007)(3613699003)(86362001)(33656002)(38100700002)(166002)(38070700009)(55016003)(19627405001);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?knel7VfT794IvMSHrOdeTVdKbj1YiXE2ScrEN2o+iJ5Rg/Gh6N+ZoePaFU?=
 =?iso-8859-1?Q?24GHeLMeKsto32P+Q+SoNZL7lUGJlpDnP5N++BoJlc7TdWG2t+xQhI2Hyf?=
 =?iso-8859-1?Q?uNGXy6r77vLbQ7L3Dw4q571Y5digjO1BwoG3AcSRkPS0JlPrbCiQhJitFz?=
 =?iso-8859-1?Q?BX4YRAZzpaX2QHVi6y+h6FFnPVJe+8Z9nkxSw7uHG4mLZOP3e9O8GCVb4v?=
 =?iso-8859-1?Q?RSVnz1z+DEGdywLhL5D3z1LDdtYIqtUHqO3+49HhIutE6cvQY70vZza/e1?=
 =?iso-8859-1?Q?7zNrwmrwWBTeWVsxW7VczS0AnXr5TlU1Nrulhl56pr6b1kOcp+SwRvLAJ/?=
 =?iso-8859-1?Q?zB/okuTmPR1E2iTtCCxrduVtL1KMkP508oKsNmTGIOz2KQjd7nUDeUW8o3?=
 =?iso-8859-1?Q?zHLeoFrjDgHykVgtUcvZ++KqBId/28h/WEXPxwx0PuIaBqUUY37jr7pWCX?=
 =?iso-8859-1?Q?9HzCz7rL7LOjmyS6xNp4Gd/V2o2TCoMGZQ3WyVSkPcNaB8L79r4byVyoeY?=
 =?iso-8859-1?Q?LuF7+yRn9ZlOKzTvBxhpPEyMmg2fvPVheYogMmwzgRf4mYXhfyumUn9mcm?=
 =?iso-8859-1?Q?uS3sseJKD1xrREZxZISOsvbNU2CVRjiL1SLKaAAaLYtDVJBX3vMuEofdrd?=
 =?iso-8859-1?Q?3T8twn5lkLZz0rFarUXDtcOBH2JKzBl1gg/fajjUEBmPoMxSQJB35YYoRg?=
 =?iso-8859-1?Q?o6qjeJMtWptkAyrDFCxcyBOzv0AKQagDUtkbJ21RaIligS4Ja0wwc3zkpB?=
 =?iso-8859-1?Q?ZmOAdr0V/CT5XKpD3UcHwLXgQEby03yMgKOaRvPATRMvMsCcy6fAscCnqn?=
 =?iso-8859-1?Q?bsE/4BurbHHuJ568RAXynFTYzf2j+2aCikiQLaMLntZkV4jlY6XiIdd9Yv?=
 =?iso-8859-1?Q?tECAcbOFfAWzwWAK9p6nAurkb9aTUijdem2kPHwlMY3yKGkJPKKAJL1WrR?=
 =?iso-8859-1?Q?FsOZqhCwlZL45XKoVKHnWj3ru7hNFVRpuILiz8aVjueUp2BFEE4R846Mrp?=
 =?iso-8859-1?Q?7b8LgoY+vOHOHklYwLDCAmYHbinlaDA0rPLcJhRIU0HBepqTy4NB9HyaYf?=
 =?iso-8859-1?Q?Ipj+GLQqq8eKpfyUHTdrDPAo0ynIiBcl6gJoUzboLh1nufQXA404j2P4ND?=
 =?iso-8859-1?Q?ukAYwty23uMal0Ye8NJLVyjCuU3fe1/7oGMK9C0d82wOEnrGQcXdMqz5z9?=
 =?iso-8859-1?Q?9qAzNje+6TGULJs+SyszRE4vrlors486N7AS46CuqIBGGEQofo7oXp9E7U?=
 =?iso-8859-1?Q?p4hmOr7BDh+0mYNzgmPlWRoken1/FuytqSKpMA1bV0KN7w3UGUdZFnh7KB?=
 =?iso-8859-1?Q?7yAVCldbULXekqvuOy9eqktuxfGEfoLG4yhh/sy97B6yB0GwdP1BKLBuLA?=
 =?iso-8859-1?Q?zlEXKh0+7ehiJ1HAmjR9s26Bzg2PW1M4C/jlnD/0MYKWmHs+5WxMmwXxAn?=
 =?iso-8859-1?Q?0a+BHX+gqc2qpI8KtvslSlBYagmmEsbA3EqSbicjgTbEt2uE3belWcVLTn?=
 =?iso-8859-1?Q?cDgNRPAwUGr6bzMQW6/T8gtVK5j1vPlbztwifG+LcvqdaIKeN4drIJpJHd?=
 =?iso-8859-1?Q?CUYs1xoAJRSntsM2HS3RrPHYqWMz8Cl8/XdlFOPXdOIIX1fXToyQORvuh9?=
 =?iso-8859-1?Q?xyOYADrF0cendosPCzbpEtO1PCD+GGMcqK?=
Content-Type: multipart/alternative;
	boundary="_000_BM1PR01MB371413CB7A7DC039C8892ECB8F94ABM1PR01MB3714INDP_"
MIME-Version: 1.0
X-OriginatorOrg: alumnux.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BM1PR01MB3714.INDPRD01.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 061085d1-6580-4fa9-b33c-08dc02f9228a
X-MS-Exchange-CrossTenant-originalarrivaltime: 22 Dec 2023 14:20:22.8843
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 3fef5931-0c12-4eb9-b22f-ffd793ead03d
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 jbUxpowhulJpOEgLhq1sJegfNPtqPUfb/YA5yey+EWXgl6FuR1WMW9e2gpq12inxBDMs4+iWZ+Fq2s/P8T7cBPGUk3qGXM3k0opQvuIHOt4=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MA0PR01MB7236
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/BM1PR01MB371413CB7A7DC039C8892ECB8F94A%40BM1PR01MB3714.INDPRD01.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_BM1PR01MB371413CB7A7DC039C8892ECB8F94ABM1PR01MB3714INDP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Folks,

I recently posted a question on the Database Administrators Stack Exchange =
platform<https://dba.stackexchange.com/> that I believe aligns with the exp=
ertise 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-default-index-index-on-id-of>

I am eager to hear any thoughts or explanations you might have regarding th=
is observed size difference. Have you encountered similar scenarios, and do=
 you have any recommendations or explanations for this phenomenon?

Ezhar

--_000_BM1PR01MB371413CB7A7DC039C8892ECB8F94ABM1PR01MB3714INDP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
Hi Folks,</div>
<div class=3D"elementToProof" style=3D"font-family: Aptos, Aptos_EmbeddedFo=
nt, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 12pt; c=
olor: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof"><span style=3D"font-family: Aptos, Aptos_Embe=
ddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 1=
2pt; color: rgb(0, 0, 0);">I recently posted a question on the
<a href=3D"https://dba.stackexchange.com/" id=3D"LPlnk873968" class=3D"OWAA=
utoLink" title=3D"https://dba.stackexchange.com/">
Database Administrators Stack Exchange platform</a>&nbsp;that I believe ali=
gns with the expertise of your community. The question revolves around the =
size difference between a composite index and a default index on the 'ID' c=
olumn. The link to the question is provided
 below:</span></div>
<div><span style=3D"font-family: Aptos, Aptos_EmbeddedFont, Aptos_MSFontSer=
vice, Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);=
"><br>
</span></div>
<div class=3D"elementToProof"><span style=3D"font-family: Aptos, Aptos_Embe=
ddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 1=
2pt; color: rgb(0, 0, 0);"><a href=3D"https://dba.stackexchange.com/questio=
ns/334284/why-the-size-of-composite-index-is-less-than-the-default-index-in=
dex-on-id-of" id=3D"LPlnk948820" class=3D"OWAAutoLink" title=3D"https://dba=
.stackexchange.com/questions/334284/why-the-size-of-composite-index-is-less=
-than-the-default-index-index-on-id-of">Why
 the size of composite index is less than the default index (index on ID)?<=
/a></span></div>
<div class=3D"elementToProof"><br>
</div>
<div class=3D"elementToProof">I am eager to hear any thoughts or explanatio=
ns you might have regarding this observed size difference. Have you encount=
ered similar scenarios, and do you have any recommendations or explanations=
 for this phenomenon?</div>
<div class=3D"elementToProof"><br>
</div>
<div class=3D"elementToProof"><span style=3D"font-family: Aptos, Aptos_Embe=
ddedFont, Aptos_MSFontService, Calibri, Helvetica, sans-serif; font-size: 1=
2pt; color: rgb(0, 0, 0);">Ezhar</span></div>
</body>
</html>

--_000_BM1PR01MB371413CB7A7DC039C8892ECB8F94ABM1PR01MB3714INDP_--