[snip] > Have you tried reindexing your active tables? > Not yet, the db is in production use and I have to plan for a down-time for that... or is it not impacting the activity on the table ?
> Emil > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings