Re: Need for rebuilding index after many deletions?

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