Re: A few new options for vacuumdb

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: "Bossart, Nathan" <bossartn(at)amazon(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: A few new options for vacuumdb
Date: 2019-01-31 02:03:35
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Wed, Jan 30, 2019 at 05:45:58PM +0000, Bossart, Nathan wrote:
> On 1/29/19, 4:47 PM, "Michael Paquier" <michael(at)paquier(dot)xyz> wrote:
>> Oh, OK. This makes sense. It would be nice to add a comment in the
>> patch and to document this calculation method in the docs of
>> vacuumdb.
> Sure, this is added in v8.

Thanks, Nathan.

Something which was not correct in the patch is the compatibility of
the query. xid <> xid has been added in 9.6, so the new options will
not be able to work with older versions. The versions marked as
compatible in the last patch came from the age-ing functions, but you
added direct comparisons with relfrozenxid and relminmxid in the
latest versions of the patch. This implementation goes down a couple
of released versions, which is useful enough in my opinion, so I would
keep it as-is.

I have added as well some markups around "PostgreSQL" in the docs, and
extra casts for the integer/xid values of the query. The test
patterns are also simplified, and I added tests for incorrect values
of --min-xid-age and --min-mxid-age. Does that look correct to you?

> Thanks. Something else I noticed is that we do not retrieve foreign
> tables and partitioned tables for --analyze and --analyze-only.
> However, that has long been the case for parallel mode, and this issue
> should probably get its own thread.

Good point, this goes down a couple of releases, and statistics on
both may be useful to compile for a system-wide operation. Spawning a
separate thread looks adapted to me.

Attachment Content-Type Size
vacuumdb-min-age-v9.patch text/x-diff 9.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2019-01-31 02:19:11 Re: [PATCH] Pass COPT and PROFILE to CXXFLAGS as well
Previous Message Kyotaro HORIGUCHI 2019-01-31 01:43:36 Re: psql exit status with multiple -c or -f