| From: | Hao Zhang <kennthhz(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: REINDEX vs VACUUM |
| Date: | 2023-01-03 17:57:26 |
| Message-ID: | CAGXpB2m-OW46r7+mi2LR7BuBc5FApFyuydCxrT=UNvWahxjfsQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
+ pgsql-admin
Would appreciate any insights. Thanks
On Sat, Dec 31, 2022 at 1:04 PM Hao Zhang <kennthhz(at)gmail(dot)com> wrote:
> What is the difference between reindex and vacuum's impact on index file?
> I deleted an indexed row. Running either vacuum or reindex shows the index
> entry for the row is removed from the index page. I was under the
> impression that only reindex will remove dangling index entries. I am
> guessing that vacuum will not shrink the index file and will only add
> deleted index entries in the free space file for the index? But REINDEX is
> recreating the index file from scratch so it is like vacuum full for index?
>
> Thanks
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rébeli-Szabó Tamás | 2023-01-04 13:25:25 | Re: REINDEX vs VACUUM |
| Previous Message | Zwettler Markus (OIZ) | 2023-01-03 16:03:01 | postgres restore & needed history files |