cancel
Showing results for 
Search instead for 
Did you mean: 

Growing TOAST table size and vacuum

Highlighted
Adventurer

Growing TOAST table size and vacuum

Hi,

 

There is a table with total relation size of around 19 GB , the relation size is just 200MB and most of the 19GB is used by it's toast table.

 

1) I don't see any dead tuples for the toast table but still it seems too large.How can we compress the toast table size ?

2) How can we find bloating on the toast table?

 

Thanks in advance!

 

Regards,

Nikhil

1 REPLY
Level 2 Adventurer

Re: Growing TOAST table size and vacuum

Did you vacuum full to the table? vacuum full help to recover disk space

 

you can check that blog to see bloating 

https://www.citusdata.com/blog/2017/10/20/monitoring-your-bloat-in-postgres/

 

regards