pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Michael Paquier <michael@paquier.xyz>
To: Bossart, Nathan <bossartn@amazon.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: A few new options for vacuumdb
Date: Sat, 5 Jan 2019 10:19:41 +0900
Message-ID: <20190105011941.GD4849@paquier.xyz> (raw)
In-Reply-To: <579F2B3A-4EA5-4032-AAD9-4AEE9219A4AB@amazon.com>
References: <FFE5373C-E26A-495B-B5C8-911EC4A41C5E@amazon.com>
	<20181220020522.GM27104@paquier.xyz>
	<7B4ACE8E-5D81-416B-B984-17E60F7ABABA@amazon.com>
	<CA+TgmoaQ+h-gNAn3LL3Sn=_JVOGg8QDiRY1V6t4ECqPVWFTH=g@mail.gmail.com>
	<33F59F9F-78A6-4ECE-BFE0-B1E4AAF40094@amazon.com>
	<579F2B3A-4EA5-4032-AAD9-4AEE9219A4AB@amazon.com>

On Fri, Jan 04, 2019 at 11:49:46PM +0000, Bossart, Nathan wrote:
> 0004 introduces a slight change to existing behavior.  Currently, if
> you specify a missing table, vacuumdb will process each table until
> it reaches the nonexistent one, at which point it will fail.  After
> 0004 is applied, vacuumdb will fail during the catalog query, and no
> tables will be processed.

I have not looked at the patch set in details, but that would make
vacuumdb more consistent with the way VACUUM works with multiple
relations, which sounds like a good thing.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (35+ messages)  latest in thread

Message-ID: <20190105011941.GD4849@paquier.xyz>
Permalink:  ../20190105011941.GD4849@paquier.xyz/
Also on:    postgresql.org/message-id/20190105011941.GD4849@paquier.xyz

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: michael@paquier.xyz, bossartn@amazon.com, robertmhaas@gmail.com
  Subject: Re: A few new options for vacuumdb
  In-Reply-To: <20190105011941.GD4849@paquier.xyz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox