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(dot)klaver(at)aklaver(dot)com