Thread: Vacuum/Analyze (suddenly) too slow

A vacuum analyze that used to take about 3 minutes on a table of about
4 million rows is now taking up to 25 minutes. I changed the
statistics on two index columns to 100 recently, to improve planner
estimates. Could this have something to do with the lack of speed?

"Phoenix Kiula" <phoenix.kiula@gmail.com> writes:

> A vacuum analyze that used to take about 3 minutes on a table of about
> 4 million rows is now taking up to 25 minutes. I changed the
> statistics on two index columns to 100 recently, to improve planner
> estimates. Could this have something to do with the lack of speed?

That sounds about right. It's sampling 10x as much of the table and it's
taking almost 10x as long...

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com