Re: REINDEX backend filtering

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: REINDEX backend filtering
Date: 2021-03-15 03:33:20
Message-ID: 20210315033320.4273frstqn7w6kh7@nol
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Please find attached v7, with the following changes:

- all typo reported by Michael and Mark are fixed
- REINDEX (OUTDATED) INDEX will now ignore the index if it doesn't have any
outdated dependency. Partitioned index are correctly handled.
- REINDEX (OUTDATED, VERBOSE) will now inform caller of ignored indexes, with
lines of the form:

NOTICE: index "index_name" has no outdated dependency

- updated regression tests to cover all those changes. I kept the current
approach of using simple SQL test listing the ignored indexes. I also added
some OUDATED option to tests so that we also check that both
REINDEX and REINDEX(OUTDATED) work as expected.
- move pg_index_has_outdated_dependency to 0002

I didn't remove index_has_outdated_collation() for now.

Attachment Content-Type Size
v7-0001-Add-a-new-OUTDATED-filtering-facility-for-REINDEX.patch text/x-diff 22.3 KB
v7-0002-Add-a-outdated-option-to-reindexdb.patch text/x-diff 18.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Julien Rouhaud 2021-03-15 03:54:55 Re: pl/pgsql feature request: shorthand for argument and local variable references
Previous Message Bharath Rupireddy 2021-03-15 03:32:02 Re: EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW