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.