Need for rebuilding index after many deletions?

From: Patrick Robin <Patrick(dot)Robin(at)disney(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Stephen Bowline <Stephen(dot)Bowline(at)disney(dot)com>
Subject: Need for rebuilding index after many deletions?
Date: 2000-08-04 15:59:58
Message-ID: 398AE87D.8D1A913@fa.disney.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces


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(at)fa(dot)disney(dot)com
Walt Disney Feature Animation
500 South Buena Vista Street
Burbank,California 91521-4817

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Anderson 2000-08-04 17:34:06 Database Connection Restriction Problems
Previous Message Bruce Momjian 2000-08-04 15:47:26 Re: [HACKERS] pg_dump/restore to convert BLOBs to LZTEXT (optiona l!)

Browse pgsql-interfaces by date

  From Date Subject
Next Message David Lloyd-Jones 2000-08-04 16:31:26 Re: Python + PostgreSQL
Previous Message Bob Kline 2000-08-04 14:04:08 Re: Python + PostgreSQL