Postgres Pro
Downloads
Home   >   mailing lists

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

From Patrick Robin
Subject Need for rebuilding index after many deletions?
Date
Msg-id 398AE87D.8D1A913@fa.disney.com
Whole thread Raw
In response to Embedded SQL C++ preprocessor ?  ("luc00" <lucian00@hotpop.com>)
List pgsql-general
Tree view 
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: Bruce Momjian
Date:
Subject: Re: [HACKERS] pg_dump/restore to convert BLOBs to LZTEXT (optiona l!)
Next
From: Craig Anderson
Date:
Subject: Database Connection Restriction Problems