Jonathan Blitz writes:
So, I have tried to run the following command. The command never finishes (I gave up after about and hour and a half!).
Did you ever find what was the problem? Perhaps you needed to run a vacuum full on the table? ---------------------------(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