Aaron Turner wrote:
So I'm trying to figure out how to optimize my PG install (8.0.3) to get better performance without dropping one of my indexes.
What about something like this: begin; drop slow_index_name; update; create index slow_index_name; commit; vacuum; Matt