Postgres Pro
Downloads
Home   >   mailing lists

Re: Need for rebuilding index after many deletions? - Mailing list pgsql-general

From philip@adhesivemedia.com (Philip Hallstrom)
Subject Re: Need for rebuilding index after many deletions?
Date
Msg-id 200008041900.MAA48145@illiad.adhesivemedia.com
Whole thread Raw
In response to Need for rebuilding index after many deletions?  (Patrick Robin <Patrick.Robin@disney.com>)
Responses Re: Re: Need for rebuilding index after many deletions?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I could be wrong, but you also need the -a (analyze) option to vacuum to
have it "re-think" it's lookup strategies, right?
In article <am.pgsql.general.965411449.47605@illiad.adhesivemedia.com>,
Jeffrey A. Rhines <jrhines@email.com> wrote:
>If you're worried about performance, a vacuum should do the trick,
>right?
>
>Jeff
>
>Patrick Robin wrote:
>>
>> Hi all,
>>
>>    With Postgres 6.5.2,  if a table has undergone several row deletions,
>> does it make sense/ is it needed  to rebuild the index?  Would this be
>> accomplished by
>> dropping it and then recreating it?

pgsql-general by date:

Previous
From: Christopher Masto
Date:
Subject: Re: random() function produces wrong range
Next
From: "Dale Anderson"
Date:
Subject: Upper limit of a TEXT field