On Nov 20, 2007, at 1:04 PM, Josh Harrison wrote:
I ran vacuum full on this table already. I haven't re-indexed it. But
this will not affect the table size...right...since indexes are stored
separately?
Yes, but your indexes are probably bloated at this point, so to reduce
the space they use run a reindex.
---------------------------(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
