My application creates temp table frequently. Now I find 
pg_attribute  table is growing larger and larger, 90GB now.
pgstattuple shows 82% free space, so I restored the db to dev env, and tried 
vacuum full to shrink it.
However, the vacuum full run for 24 hours, and hang there. I can see a CPU is 
on 100% usage, no disk activity.
looks like a bug of vacuum full. my pg version is 9.6.1. auto_vacuum uses 
default value.
Does anyone has this issue before? how to shrink the pg_attribute table? and 
what is the best configuration for auto_vacuum parameter? thanks


Reply via email to