From: Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Observation with Postgres table size
Thread-Topic: Observation with Postgres table size
Thread-Index: AQHaouEZmMdOq8tvR0yRgSz7rtmyxw==
Date: Fri, 10 May 2024 13:57:23 +0000
Message-ID: 
 <DB4PR10MB7469DCC3427E61FEEE2F8D6F8CE72@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
Accept-Language: en-IN, en-US
Content-Language: en-IN
msip_labels: 
x-ms-exchange-messagesentrepresentingtype: 1
x-tmn: [Tmrar7CGXwlCXFnGKr5TPaDLoilY8Nh/vX7XvT9+cLo=]
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: DB4PR10MB7469:EE_|AS8PR10MB7065:EE_
x-ms-office365-filtering-correlation-id: 4a45f10d-7852-4d93-f95d-08dc70f91de8
x-microsoft-antispam: 
 BCL:0;ARA:14566002|461199019|102099023|3412199016|440099019;
x-microsoft-antispam-message-info: 
 cjvE4yFecEqKaAkC34BSP8evP0wRqZj6h2mdZIeY7kb+nRJKfVYyW+SPf1ZfkzpYokscGpwVGf/Q0ZnwesgEwnjUYPGeEbONreHH50uBjTETaEwSaoTq/EQomAQ28KZzdtUdq/jQEzgepYLdC6wsarIyFMJ6Sqqn/E6tR2vyPN9X1lkXGTdTZuJ6YzBw+wWezmwPvohDH0FwTZKed2bXE9Z+DRunb7mY3sbjPmFkY9d1jM6YlqcnDns2eaQuBPI/eQ2OYsOusH8bzsRIZW6cWBa8nScJXooeWKqZe0B39Y73WsqOfg2mr+DogUtHt2qVYkwIYhjoErIOUnOf8f56BNqFK4SFYH/4BdDTBaQuDhAlmJt2F8Enr2G45H0/ndvBO7zvRIAnUkLZczYncft4SJ8Aox/P5mahRk38pOEHOsgR30vCg0hZwfw6qBUIkI/mR8v57Smu+iUnNp+OGtFwju5aejKQPyP7ScsMS5o99ZgAnJ3Xw57LJZX7sHVTniHYJYfQa7gOBWkT2N/XZAFDwGw4l4HRREGfEnf7MBOHBw/n8ijXGN84Ld3DnA4ScpuN
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?1QI0I5/zakhvWJVkohwoqb0qoRpR7XzcO2+zFcmMfvaBgN8HshmIs5aOYQ?=
 =?iso-8859-1?Q?qFD7JN1XvhsuWOGjltsq1mW0wdID9HInwe2BURXkOBwOg2+CBNz/9LUj+g?=
 =?iso-8859-1?Q?e1evVAjiBVCJ2+00QvS1y08hGi5XStu0obxI0fB4WSMEkXoU5k0Y5BnP2c?=
 =?iso-8859-1?Q?OSOCqqHKUiI0vy7WEjCGBqYzIZvGHIEz6iIYfVM6BxaWHmlKar4EbWTzLO?=
 =?iso-8859-1?Q?7sbFT2nC5Km6Wfe+fy8f+gLqJBlTlb3gnZjbbufUWHQaPAsJfnGTqT83e+?=
 =?iso-8859-1?Q?wp79eSQhd3c/V1DtM8W+boHiCRRWSDbsVspaptwMSYXABA6oj4Mw60ff3O?=
 =?iso-8859-1?Q?H5uQLkvvb1DShMspEYVRqLV6F18HWoYakW4En5ldp3D9b3BWx2WNZMX5xY?=
 =?iso-8859-1?Q?2fxpXag/s5uIgKtgitK/IOFigtVCkirH1DJsZpl6xzHEeEV5Pts3YkbI2Q?=
 =?iso-8859-1?Q?m3r2yvMhp19/eREEnb0Rvxx/jKGHDYjN38o5CU26f0xa8DnFZws8IhQs1o?=
 =?iso-8859-1?Q?KcDluhKOr0LsTgvG5Gsmk4KsWaTcukSHzegfzU5ycfxHZlxJGpHk0+JU3x?=
 =?iso-8859-1?Q?XLRS3nK3ChSa3AAzk8/vC59YMzEkVVk7wL0AJb3ZVuPmfXrhunvdKLfKS9?=
 =?iso-8859-1?Q?3x3khSiGMVhd0+8hBx7gjJL/jsSErGvb2d9/VODqALAtCRK2PYG6BolspB?=
 =?iso-8859-1?Q?+WbElA0k6zV1t1ou39E154pc2cfNjbNxerBy32zxEfcT2J+vT6arNrMbOb?=
 =?iso-8859-1?Q?sWa2AP/zsMy2pZaInLPiTpvYMnCB59ntBZSDvwjP0nAf9CAU3773vw/BCg?=
 =?iso-8859-1?Q?b8rYnaS7240R5enU4xX4kLINe1gFr96EL1ouvSFs0xHGTwiKuHjLDU3Ug9?=
 =?iso-8859-1?Q?EAWUUryfORlDLSPUWewP5ytUWFCjFp/ZzJDpZOzUO3vDCFGFD2hXRAo5n+?=
 =?iso-8859-1?Q?ehtHjIcagfaUl9h/iIRsrpy38+96Mn86ZPNBTHVHiIS70EUx4znRCoN/eG?=
 =?iso-8859-1?Q?ugZfMVuJ8F11EZSTKkGJpuD1nzEKRJ5f1JPAxWLRFqK1JbiO3Ku98qdg55?=
 =?iso-8859-1?Q?C6dFRJStw5pqZFtOWlXNfok+SnraifHECg+TL3MyR02jNDUwijg7yWYMHu?=
 =?iso-8859-1?Q?Nvw3WdmXB2pax8o/8AbHADoS7uj6A864fyAg0m4efiVHuDiMkeeX+GnQnO?=
 =?iso-8859-1?Q?h1yScmEH/pY3+ji2TV7SShpqsACphVHpvWyKkB168FaXIVHC40d8auqBKd?=
 =?iso-8859-1?Q?fTpLWwjAWLQxJOwEJmrh8/3b+J77twb7iSOiyFITKpeVQOkGdpu6wt2ZLU?=
 =?iso-8859-1?Q?0T/3?=
Content-Type: multipart/alternative;
	boundary="_000_DB4PR10MB7469DCC3427E61FEEE2F8D6F8CE72DB4PR10MB7469EURP_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 4a45f10d-7852-4d93-f95d-08dc70f91de8
X-MS-Exchange-CrossTenant-originalarrivaltime: 10 May 2024 13:57:23.0632
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS8PR10MB7065
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/DB4PR10MB7469DCC3427E61FEEE2F8D6F8CE72%40DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
Precedence: bulk

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

Hello All,

I am having an issue with the size of a Postgres DB table.
The table have 17 columns. Out of them 5 jsonb columns. The table had 47000=
0 rows when I checked from DBBeaver it showed the table size 34GB. After I =
deleted many rows from the table - it has currently 27038 rows. But the siz=
e of the table still shows 34GB.
I was expecting the size of the DB table to be reduced.
I event restarted the PG DB server service.
I am using Postgres v16 .
Can any body please advise, how to reduce the size of the table?

Sabyasachi Mukherjee

--_000_DB4PR10MB7469DCC3427E61FEEE2F8D6F8CE72DB4PR10MB7469EURP_
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: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hello All,</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I am having an issue with the size of a Postgres DB table.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The table have 17 columns. Out of them 5 jsonb columns. The table had 47000=
0 rows when I checked from DBBeaver it showed the table size 34GB. After I =
deleted many rows from the table - it has currently 27038 rows. But the siz=
e of the table still shows 34GB.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I was expecting the size of the DB table to be reduced.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I event restarted the PG DB server service.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I am using Postgres v16 .</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Can any body please advise, how to reduce the size of the table?</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Sabyasachi Mukherjee</div>
</body>
</html>

--_000_DB4PR10MB7469DCC3427E61FEEE2F8D6F8CE72DB4PR10MB7469EURP_--