Re: A few new options for vacuumdb
Nathan Bossart <bossartn@amazon.com>
From: "Bossart, Nathan" <bossartn@amazon.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>, Robert Haas <robertmhaas@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2019-01-28T21:58:17Z
Lists: pgsql-hackers
Attachments
- v6-0001-Export-split_table_columns_spec-for-use-in-vacuum.patch (application/octet-stream) patch v6-0001
- v6-0002-Always-use-a-catalog-query-to-discover-tables-to-.patch (application/octet-stream) patch v6-0002
- v6-0003-Add-min-xid-age-and-min-mxid-age-options-to-vacuu.patch (application/octet-stream) patch v6-0003
On 1/27/19, 9:57 PM, "Michael Paquier" <michael@paquier.xyz> wrote: > I think that the query generation could be simplified by always using > the CTE if column lists are present or not, by associating NULL if no > column list is present, and by moving the regclass casting directly > into the CTE. Yes, this simplifies the code quite a bit. I did it this way in v6. Nathan
Commits
-
Add --min-xid-age and --min-mxid-age options to vacuumdb
- 00d1e88d3668 12.0 landed
-
Do not filter by relkind in vacuumdb's catalog query if --table is used
- b8f73df0f845 12.0 landed
-
Use catalog query to discover tables to process in vacuumdb
- e0c2933a767c 12.0 landed
-
Add TAP tests for vacuumdb with column lists
- 0803b0ae1ed6 12.0 landed
-
Make vacuumdb test regex more modular for its query output
- adaaacae658e 12.0 landed
-
Adjust documentation for vacuumdb --disable-page-skipping
- efab708997dc 12.0 landed
-
Add --disable-page-skipping and --skip-locked to vacuumdb
- 354e95d1f212 12.0 landed