Thanks Justin for prompt response. Could you please provide the full email for pgsql-user? pgsql-u...@postgresql.org<mailto:pgsql-u...@postgresql.org> is not working
From: Justin Pryzby <pry...@telsasoft.com> Date: Tuesday, 15 November 2022 at 9:02 PM To: Karthik Jagadish (kjagadis) <kjaga...@cisco.com> Cc: pgsql-hack...@postgresql.org <pgsql-hack...@postgresql.org>, Prasanna Satyanarayanan (prassaty) <prass...@cisco.com>, Chandruganth Ayyavoo Selvam (chaayyav) <chaay...@cisco.com> Subject: Re: Vacuumdb --force-index-cleanup option not available in postgres 12.9 On Tue, Nov 15, 2022 at 02:45:37PM +0000, Karthik Jagadish (kjagadis) wrote: > Hi, > > In the postgres document we notice that the --force-index-cleanup option is > available in PostgreSQL server 12 and Later. We have postgres db running on > 12.9 but we don’t see this option. > > https://www.postgresql.org/docs/current/app-vacuumdb.html Those are the docs for the current version (v15). vacuumdb is a client, which can run against older (or newer) servers. The --force-index-cleanup option was added in v14, and can be used against servers back to v12. But the command-line option to the vacuumdb client doesn't exist before v14 (even though the server-side supports it). > Also we notice that vacuum is happening at regular intervals but the > space occupied by indexes is always increasing. I don't know. But this busy mailing list is for development; these questions would be better addressed to pgsql-user. -- Justin
