Size of the table is growing abnormally in my database.

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Size of the table is growing abnormally in my database.
Date: 2018-08-26 03:36:06
Message-ID: CAEHH7R4tkd4s+K5MXjVtBY6qjkwORaai0pgwy5_q-1rPWJ_DcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

One of our database size is 50gb. Out of it one of the table has 149444622
records. Size of that table is 14GB and its indexes size is 16GB.
Total size of the table and its indexes are 30GB. I have perfomred the
below steps on that table.

reindex table table_name;

vacuum full verbose analyze on table_name;

But still the size of the table and its indexes size are not reduced.
Please guid me. How to proceed further.

Structure of the table as below.

Column | Type | Modifiers | Storage | Stats
target | Description
---------------------+------------------+-----------+---------+--------------+-------------
col1 | bigint | | plain | |
col2 | double precision | | plain | |
col3 | double precision | | plain | |
col4 | double precision | | plain | |
col5 | double precision | | plain | |
col6date | date | | plain | |
tkey | integer | | plain | |
cid | integer | | plain | |
rtypeid | integer | | plain | |
rid | integer | | plain | |
ckey | bigint | | plain | |
Indexes:
"idx_tab_cid" btree (cid)
"idx_tab_ckey" btree (ckey)
"idx_tab_col6date" btree (col6date)
"idx_tab_rid" btree (rid)
"idx_tab_rtype_id" btree (rtypid)
"idx_tab_tkey" btree (tkey)

--
Regards,
Raghavendra Rao J S V
Mobile- 8861161425

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-08-26 04:16:11 Re: Size of the table is growing abnormally in my database.
Previous Message Andrew Stuart 2018-08-26 00:03:07 How can I use Postgres "ROLLBACK TO SAVEPOINT" with "FOR UPDATE SKIP LOCKED"?