Re: 10+hrs vs 15min because of just one index

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Aaron Turner <synfinatic(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 10+hrs vs 15min because of just one index
Date: 2006-02-10 17:13:35
Message-ID: 43ECC9BF.2030107@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Aaron Turner 2006-02-10 17:24:39 Re: 10+hrs vs 15min because of just one index
Previous Message Aaron Turner 2006-02-10 16:35:49 Re: 10+hrs vs 15min because of just one index