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 1uPoEF-00GTnl-2D for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Jun 2025 20:08:51 +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 1uPoED-00Fbxv-5n for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Jun 2025 20:08:49 +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 1uPoEC-00Fbxn-SO for pgsql-hackers@lists.postgresql.org; Thu, 12 Jun 2025 20:08:49 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uPoEB-001hL4-1f for pgsql-hackers@postgresql.org; Thu, 12 Jun 2025 20:08:49 +0000 Received: by mail-io1-xd33.google.com with SMTP id ca18e2360f4ac-8647e143f28so109897939f.1 for ; Thu, 12 Jun 2025 13:08:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1749758926; x=1750363726; darn=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=RamgWTm7/cvZCOyNxuE7NT/8aOzVDzAsjzEpC7Fb7/8=; b=Pg07B4ymq2JWfVpYOUCdR3gVP4fxHl5jlLguq5FE21VUWRwz+agsC0i/UrWAi/d13G 7eYacb7wiHiAjAma/0lEDZZXpd2OruPZ1amuY1ilNzsYIzdqGgpgEf8kTKnWUlRUfz8M foQPd5LYJ++coDCWfvlqt79+v3A3f5bYRh6uQZA3IBJDzuev+zJ+dVkyTukSYqE+C0el o8lzWXSNGUwPXnott4dfc1JJxlgKvlrqs0OGIKLClgy3s3d6x62BlqHQIVunJQ4gYRYV szOppKzOztfIO8Sw60bPrwViQmLTugO1YmkEcP1WLQFHijVuoqvllPH45tyFUJnkJ/+p W+ZQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749758926; x=1750363726; 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=RamgWTm7/cvZCOyNxuE7NT/8aOzVDzAsjzEpC7Fb7/8=; b=wWOC0vB+/rkaAsF9uoQTBRhLUSqL3+JlW7Op56HYhI4v9OXDkssyzyerHvkNYcVyUV yJY+Jp6vrbUAQk86Lu+ROwtx6F26n58A4+e2+mI502HCC6/lC3k3PxTmDfXceF7DL8KI I390Etx95RE2kLBdO6e2bnUxZKZlgIZyJMBzQErPaWEhdPFqdohIg259XXBTiSMRq97N pWcVdeqSc5ehhPyQFx5EDKMj7UoONxca9Uf1IPc5extEFgBglJnGXOOmxza4E4BapT79 gWmLg5cjV+H5eGo1c730NOvv/78jbyo1nUm8SknhwNJ8hEuRTgmtjewLYmVJd8uHRAS7 tDxQ== X-Forwarded-Encrypted: i=1; AJvYcCXFN6FEs9ZT7/W7JcnZ6OJNbYuTXVIS6q9Bln5UJZbfd0d6cdPCozzPeQtmvsvVZFFYfdioS/G3HK8Oi+ta@postgresql.org X-Gm-Message-State: AOJu0YzGrtn8EDV0JEqV0lCnAMzOBx8lAs4Ji6Ma3wa/CtL7WzzJtybe wgCrENsdfMR+fk+NquLUdyOCv8Y+ybzh//W8R4rFQoou/dvuEc9LD618 X-Gm-Gg: ASbGncv7s1gD63sn9bVJXTaFp9Ytz0wyylEc9tHa9+rXY/yjwzv49xs0rQTcnRQC0tt GNVgMOoOVxS0bzkfeV96uPlv95tpq+A5gsB0u2FGlc3KVxovdaW9bLoEOyhrOSq2x6biawYfM5/ Ylob445oJn8rxaboeroJMBRMZ48kWezbdqyocyOYdYYy86iyeYm13A0j7gGGxlff1/k7hRJTJJp Q4vTz6YpVtnIwOkhly6gkcd0Uz2TwcXy8BvDasI6JDpDN1mfT63yP1Kj7v9XXjR6hHUCLa7glEc x5skS4B9Guz0mwBUqNUROpEWKpHcVT/90VZ/BeZhta4wMDMtKCSI74ORoZ+r1pVNDH7U7aOoki1 t32G9tNk1QDINgkY7G1an30nODv3TZEDxDE8mDgRBrS3NjA1/1+PGN8VOqvMFALw= X-Google-Smtp-Source: AGHT+IHLmnSktmqOqwF7O+XdpSSG8+Tl+IVD3MwBSI3mJCAxxGlgS/eFQy9b/ay8yPACd6/SoClJ5w== X-Received: by 2002:a05:6e02:2482:b0:3dd:89b0:8e1b with SMTP id e9e14a558f8ab-3de00b9e40amr3770275ab.15.1749758925781; Thu, 12 Jun 2025 13:08:45 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-3ddfbace963sm5918805ab.46.2025.06.12.13.08.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Jun 2025 13:08:45 -0700 (PDT) Date: Thu, 12 Jun 2025 15:08:43 -0500 From: Nathan Bossart To: Laurenz Albe Cc: Robert Haas , Jeff Davis , Peter Eisentraut , pgsql-hackers Subject: Re: pg_dump --with-* options Message-ID: References: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org> <7bf0246542713d80f12c738c1d365d1365750c18.camel@j-davis.com> <89c167ef628e5fa32ea0be433e61df8971e9641c.camel@cybertec.at> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <89c167ef628e5fa32ea0be433e61df8971e9641c.camel@cybertec.at> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jun 12, 2025 at 10:07:05PM +0200, Laurenz Albe wrote: > I must be missing something, but I think --no-statistics is sorely needed. > How else can I get the effect of > > pg_dump --no-statistics mydb This was recently changed to be the default behavior (see commit 34eb2a8). -- nathan