Vacuumdb --force-index-cleanup option not available in postgres 12.9

Поиск
Список
Период
Сортировка
От Karthik Jagadish (kjagadis)
Тема Vacuumdb --force-index-cleanup option not available in postgres 12.9
Дата
Msg-id IA1PR11MB61705AF334634DA8E220A976D8049@IA1PR11MB6170.namprd11.prod.outlook.com
обсуждение исходный текст
Ответы Re: Vacuumdb --force-index-cleanup option not available in postgres 12.9  (Justin Pryzby <pryzby@telsasoft.com>)
Index not getting cleaned even though vacuum is running  ("Karthik Jagadish (kjagadis)" <kjagadis@cisco.com>)
Список pgsql-hackers

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

 

 

 

Is this option enabled by default? Any pointers here?

 

Also we notice that vacuum is happening at regular intervals but the space occupied by indexes is always increasing.

 

Some outputs below. Auto vacuum is enabled but we notice index size is growing.

 

$ psql -U postgres -d cgms -c "SELECT pg_size_pretty(SUM(pg_relation_size(table_schema||'.'||table_name))) as size from information_schema.tables"

 

size

-------

25 GB

(1 row)

 

$ psql -U postgres -d cgms -c "SELECT pg_size_pretty(SUM(pg_indexes_size(table_schema||'.'||table_name) + pg_relation_size(table_schema||'.'||table_name))) as size from information_schema.tables"

  size

--------

151 GB

(1 row)

 

$ sudo du -hsc /var/lib/pgsql/12/data

154G    /var/lib/pgsql/12/data

154G    total

 

Appreciate if someone can give some pointers.

 

Regards,

Karthik

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ranier Vilela
Дата:
Сообщение: Re: Avoid overhead open-close indexes (catalog updates)
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Check return value of pclose() correctly