| From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
|---|---|
| To: | William Scott Jordan <wsjordan(at)brownpapertickets(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: VACUUM vs. REINDEX |
| Date: | 2006-07-07 23:15:27 |
| Message-ID: | 20060707231527.92786.qmail@web31814.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> I'm trying to decide now if we need to include a daily REINDEX along
> with our daily VACUUM FULL, and more importantly I'm just curious to
> know why we should or shouldn't do that.
>
> Any information on this subject would be appreciated.
My understanding is that vaccum full frees all of the unused space from deprecated tuples in the
table. This effective reduces that amount of tuples that will be sequencially scanned which
deceases sequencial scan times.
reindex rebuilds the index to removed all of the deprecated tuple references. This free memory
and reduces that time it takes to scan the index.
Thats how I understand it.
Regards,
Richard Broersma Jr.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Frost | 2006-07-07 23:18:40 | Re: VACUUM vs. REINDEX |
| Previous Message | William Scott Jordan | 2006-07-07 22:29:19 | VACUUM vs. REINDEX |