| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add more tests for VACUUM skips with partitioned tables |
| Date: | 2018-08-24 00:16:20 |
| Message-ID: | E1fszm0-0005Zq-GE@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Add more tests for VACUUM skips with partitioned tables
A VACUUM or ANALYZE command listing directly a partitioned table expands
it to its partitions, causing all elements of a tree to be processed
with individual ownership checks done. This results in different
relation skips depending on the ownership policy of a tree, which may
not be consistent for a partition tree. This commit adds more tests to
ensure that any future refactoring allows to keep a consistent behavior,
or at least that any changes done are easily identified and checked.
The current behavior of VACUUM with partitioned tables is present since
10.
Author: Nathan Bossart
Reviewed-by: Michael Paquier
Discussion: https://postgr.es/m/DC186201-B01F-4A66-9EC4-F855A957C1F9@amazon.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/a569eea6998a26689409ff6eb5fce2c1eab0f5e1
Modified Files
--------------
src/test/regress/expected/vacuum.out | 99 ++++++++++++++++++++++++++++++++++++
src/test/regress/sql/vacuum.sql | 57 +++++++++++++++++++++
2 files changed, 156 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2018-08-24 01:41:19 | pgsql: Introduce minimal C99 usage to verify compiler support. |
| Previous Message | Andres Freund | 2018-08-23 23:59:35 | pgsql: Deduplicate code between slot_getallattrs() and slot_getsomeattr |