Re: 10+hrs vs 15min because of just one index - Mailing list pgsql-performance

From Matthew T. O'Connor
Subject Re: 10+hrs vs 15min because of just one index
Date
Msg-id 43ECC9BF.2030107@zeut.net
Whole thread Raw
In response to 10+hrs vs 15min because of just one index  (Aaron Turner <synfinatic@gmail.com>)
Responses Re: 10+hrs vs 15min because of just one index  (Aaron Turner <synfinatic@gmail.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Aaron Turner
Date:
Subject: Re: 10+hrs vs 15min because of just one index
Next
From: Aaron Turner
Date:
Subject: Re: 10+hrs vs 15min because of just one index