Vacuum/Analyze (suddenly) too slow

"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