Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuedN-00ATjl-8E for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Mar 2025 21:38:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tuedL-00627d-LW for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Mar 2025 21:37:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tuedL-00627U-8v for pgsql-hackers@lists.postgresql.org; Tue, 18 Mar 2025 21:37:59 +0000 Received: from mail-yb1-xb31.google.com ([2607:f8b0:4864:20::b31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tuedH-003daZ-21 for pgsql-hackers@lists.postgresql.org; Tue, 18 Mar 2025 21:37:58 +0000 Received: by mail-yb1-xb31.google.com with SMTP id 3f1490d57ef6-e60aef2711fso4519322276.2 for ; Tue, 18 Mar 2025 14:37:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742333875; x=1742938675; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=NYh80i3xB11OazsUkVZaMx6K+1KjMPSAm0RPo+OKUrE=; b=mMQWSOojs8qKtwHNUKHiXFvePruFgSxkkC8tSr4rcJ+kHNsMOXpLsS6orK+3/agEZh J4vy/vQn1VT4m3V7fWAARRgVxuO/vjXEaeamztB7Kt0TdQsg5je6gyvsp4pU4pq+5F1w mSGqvYowjEo6qSC+iTvGoc80Ev1UCO6C3NPT0xx4ip59iAWCWPgn/3tv+QZiw+7IGxXi IXK5CESIwssBUhyYijeK0b8y89LwOVQdoDUDJG4obH9Q8QHjJVCXLN4WwEXdWZnDm3Vb 5MgRBs5px0LbIM4XsmWdSCyqJuaiLyotJoG9AYqu/v4BOkQ21l2VJUiQ/bBkXMMtn3OM i2tA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742333875; x=1742938675; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=NYh80i3xB11OazsUkVZaMx6K+1KjMPSAm0RPo+OKUrE=; b=e3Jb9Rxyc37JBC3CXGYxe4xOCpXs3clBlerduKo71llgA3mRwtgKIzVFgADk4RTuDJ rxjhIEB8ZT2bzqpsgaKP1ksYXNwqC+utV97rvROvTP4MedCiSVv54YPBIp9ZiifQQrCS 5cYHtaPbwryUYQuQ0E+mZ63ak8iL9KMQU91Gb3z2GzqU6UMf+ViOSTST0PfywUgU8lyI 1R0W5K1RNiIbDjElsWyTeDhmpiZAOsgoYqlxs8QGHo8r4nYdBdrKONXd9gauC6P0RUcj RZZjnApSsuE+kw6sCigM+H/BEW9YZ+6+52aBRVKm0GK2pWNk5o7uYhdyGVOlWA6V/xdm qoEg== X-Forwarded-Encrypted: i=1; AJvYcCWzf2zJ8+Qg5u7EYax16nmQ68CitM2memuY8KPCInTNL6Lu4CbbqrGsG6joOI8BfEnPTzN4r2kSVIYK+zkz@lists.postgresql.org X-Gm-Message-State: AOJu0YxiCymh0WOuRj9Uwnu+PKLK+iqLfhWrYm+zICMcJZbnXSMYn/o/ u6YussZ/kOTcMGpvk+O1SmZx0Zd8K/X6p6dnJiFMpKKPESq/3oHt X-Gm-Gg: ASbGncs49D1Q4LX6+Zkbn8Zb9wiacV5EnLzuRetPwWxq+0bVenv0JAxuhGawHMgBy1X 84SR7/HiSDYVTfGST6o9RBN/RFZ74r2cR0RFIljm88mvRSJIZQoJMp5gseN7qjHO0LVLanMmc71 hW/kkaoOzD04B9sZjPwb3t/reHgGNaw/WOyU7IGkb/zoF4CmSXgreJZ0XRpfJCRdtQ0Sg/SdFfi yg0oToF6moRT6tJVWwpLz/Y412BnldmWkjIWlLh0XgtsS4utiyZ3epMbkeqhrud21anhw9Ush7v Bn3jbA973twGy5unuDNx+Sah1Hrz1pekZ1/1T7ffVOUHix8m7H+z54i/rut92nPPqmEwfDakJmd W0W09811IfiDFBgMTjSe2qb9IpiIb+xZwfzI= X-Google-Smtp-Source: AGHT+IHuXscGVKi/zB+lcgeZiMOvzQSEGT+cMwR1NankiFTkD9DjlWJjik0GKheMJvHml43iRh1Hbw== X-Received: by 2002:a05:6902:2405:b0:e63:f0ac:4801 with SMTP id 3f1490d57ef6-e667b44596cmr433019276.38.1742333875320; Tue, 18 Mar 2025 14:37:55 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 3f1490d57ef6-e63e629a0a0sm2904356276.18.2025.03.18.14.37.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 18 Mar 2025 14:37:54 -0700 (PDT) Date: Tue, 18 Mar 2025 16:37:52 -0500 From: Nathan Bossart To: Corey Huinker Cc: John Naylor , Masahiko Sawada , Bruce Momjian , Jeff Davis , jian he , Matthias van de Meent , Tom Lane , Magnus Hagander , Stephen Frost , Ashutosh Bapat , Peter Smith , PostgreSQL Hackers , alvherre@alvh.no-ip.org Subject: Re: vacuumdb changes for stats import/export Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Committed with the following small changes: * I renamed the new option to --missing-stats-only, which I felt was more descriptive. * I moved the new tests to the main vacuumdb test file and interspersed some --analyze-only uses. * I fixed a couple of other things in the new parts of the catalog query that were not fully qualified. -- nathan