"Mikko Partio" <mpartio@xxxxxxxxx> writes: > Adding a new index does not speed up the query (although the planner decides > to use the index): Hm. Lots of dead rows maybe? What's your vacuuming policy? regards, tom lane
"Mikko Partio" <mpartio@xxxxxxxxx> writes: > Adding a new index does not speed up the query (although the planner decides > to use the index): Hm. Lots of dead rows maybe? What's your vacuuming policy? regards, tom lane