"Phoenix Kiula" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
