Observation with Postgres table size

From: Sabyasachi Mukherjee <mukherjee(dot)sabyasachi(at)outlook(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Observation with Postgres table size
Date: 2024-05-10 13:57:23
Message-ID: DB4PR10MB7469DCC3427E61FEEE2F8D6F8CE72@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 470000 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 size 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2024-05-10 14:00:51 Re: Observation with Postgres table size
Previous Message Wasim Devale 2024-05-10 13:49:29 Re: pgrouting and postgis