On 08/25/2018 08:36 PM, Raghavendra Rao J S V wrote:
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.
Rough approximation:
14,000,000,000 / 150,000,000 = 93 bytes/record.
I am not seeing an issue. If you want to reduce the size of the table
remove rows.
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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
