On 2019-Feb-13, Mariel Cherkassky wrote: > Hey, > I have a very big toasted table in my db(9.2.5).
Six years of bugfixes missing there ... you need to think about an update. > Autovacuum doesnt gather > statistics on it because the analyze_scale/threshold are default and as a > result autoanalyze is never run and the statistics are wrong : analyze doesn't process toast tables anyway. I think the best you could do is manually vacuum this table. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
