+ pgsql-admin Would appreciate any insights. Thanks On Sat, Dec 31, 2022 at 1:04 PM Hao Zhang <kennt...@gmail.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 >
