| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brian McCane <bmccane(at)mccons(dot)net> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: VACUUM FULL |
| Date: | 2002-05-12 15:22:28 |
| Message-ID: | 29763.1021216948@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Brian McCane <bmccane(at)mccons(dot)net> writes:
> Would I possibly see another performance boost if I rebuilt the
> indexes involved like I used to in 7.1.3? I still have the Perl script
> sitting around here some place, but assumed from things said by you and
> Bruce in the past few months about 7.2.x that it wouldn't be necessary
> anymore. I guess I'll give it a try this weekend and see what happens.
An occasional index rebuild (using either REINDEX or DROP/CREATE INDEX)
is still worth doing for heavily updated tables, especially if the range
of indexed values changes over time. That'll remain true until someone
gets around to teaching btree indexes how to collapse out free space...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-12 15:46:24 | Re: VACUUM FULL |
| Previous Message | Gaetano Mendola | 2002-05-12 15:10:56 | NOTICE: RegisterSharedInvalid: SI buffer overflow |