| 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 |
| Thread: | |
| 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 collate.icu.utf8 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 |
| 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 |