On 2/10/06, Matthew T. O'Connor <matthew@xxxxxxxx> wrote: > 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; Right. That's exactly what I'm doing to get the update to occur in 15 minutes. Unfortunately though, I'm basically at the point of every time I insert/update into that table I have to drop the index which is making my life very painful (having to de-dupe records in RAM in my application is a lot faster but also more complicated/error prone). Basically, I need some way to optimize PG so that I don't have to drop that index every time. Suggestions? -- Aaron Turner http://synfin.net/
