Re: Size of the table is growing abnormally in my database.

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@aklaver.com