Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeffrey A. Rhines
Subject Re: Need for rebuilding index after many deletions?
Date
Msg-id 398B0292.A16EDF00@email.com
Whole thread Raw
In response to Embedded SQL C++ preprocessor ?  ("luc00" <lucian00@hotpop.com>)
List pgsql-general
Tree view 
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?
>
> Thanks
>
> Patrick
>
> --
> ________________________________________
> Patrick Robin
> patrickr@fa.disney.com
> Walt Disney Feature Animation
> 500 South Buena Vista Street
> Burbank,California 91521-4817

pgsql-general by date:

Previous
From: Craig Anderson
Date:
Subject: Database Connection Restriction Problems
Next
From: Christopher Masto
Date:
Subject: Re: random() function produces wrong range