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 1uPoCf-00GTOF-Bf for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Jun 2025 20:07:13 +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 1uPoCd-00FZcA-2m for pgsql-hackers@arkaria.postgresql.org; Thu, 12 Jun 2025 20:07:11 +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 1uPoCc-00FZc1-OB for pgsql-hackers@lists.postgresql.org; Thu, 12 Jun 2025 20:07:11 +0000 Received: from mail-wm1-x333.google.com ([2a00:1450:4864:20::333]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uPoCb-001hKJ-0r for pgsql-hackers@postgresql.org; Thu, 12 Jun 2025 20:07:11 +0000 Received: by mail-wm1-x333.google.com with SMTP id 5b1f17b1804b1-4530921461aso12689675e9.0 for ; Thu, 12 Jun 2025 13:07:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1749758826; x=1750363626; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=rFPDUrGRcLSZjYZpjZ9oLB6BIixx4+bahEiLFqKMU5M=; b=d3VRQi25mu7KuDTrMhkLvhG+O7oLt6TmIszqmldhvlgAaEeqres4qIrIHGFjxm4m8c zdexn1RyTnesI9N1m4rdduAuImh4fHfV3aL6UQuzdx2XizvSxOUCXXIaNlXMMr/lM7Y6 ctl5llvT9ipboiVI3lN4bp0O/e42WePK2PPKIaaOb9IkuhivkZsbGjlZlU2AbNuZKUBg 4Sw0QyD4FU1OrF+nw5aoYE04XAV64b7l9x2jq11jIm2/nozLwWfxcx/cz7+IiohSYZsi nl+QGXStMxRBoRnFKiJz/KlpmieHINUznVFaVR6xj3m24upbTPVZecyK0QPCW0IZ1RwG bTPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749758826; x=1750363626; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=rFPDUrGRcLSZjYZpjZ9oLB6BIixx4+bahEiLFqKMU5M=; b=B95Txd6yK8j9zlChaapCRhdEnmeTcDuIxnL3t+s8KJdSWkZpgQO2DM8CD+yz1ofCsd ri/0K1O0/Gg8Hf+n1GGCSTdqCARqL7Qwr65YT5gSSYnwPxsUayKNj9H63lLOd60he2Xb aU1YupppO71tEfLUHncsIbxmEqDaT4Y2glDzBUYf9gNQNyi8FJTl6CUBlvap2U6za79D 6X0b5ZvOQDfDkJQJ34q9q4XCXh0zdlrSbABc+QGIXu9vCtJuCQXmxwi8am30sJ7U+hPG Vjt4+rK+/2d44+bZQ4e6zHKoAMx+lA8PuFy6NK3OVf1PCMWFrLKFpwCUtri2n3EdT4ox SJjw== X-Forwarded-Encrypted: i=1; AJvYcCX3Oixdi9vmP+czAfxggrWNQpzX8cYr1y5WQgSw3NSORSo42zT5EG1MCshql9aPD3LoVsR9EOE5Qawf1AmC@postgresql.org X-Gm-Message-State: AOJu0YxI40n8zMDXr2RiIcOiddX3VlTL+6u3q0GiAQaTMkBk8DflCLQS MW92DstZ2WDr5sgV6XUmq3d1Xu7Ud3huHLNWSHBv5iNLAUV3awkPWhWNKZAwOiQMHg4= X-Gm-Gg: ASbGncvt/4/mBfOtmFhHq/jefm1Mh6IS9eRuSVA66aH1Z+K3UXySkvblBU1EY7UdGND we35A3KBd6rRvQGBjcnSETOOkkpTV3CMLfPIMOiUUdzv/qLEXtiAJIrpB+Id+N7wXC8elZDe2C3 bDnnsViUD6qC+Z85hU/vgf3f7qtSypjSZhA/9UVRfeFYJxEk1fU8roT2HbsLnjZWUGkejNTRzzx fgB0qEIlvc2f6/bjSkumzdMwyP46JVYJ0YeWe+hRuEKku8r+41waDQAW89Hq0thixVuZilXenkw gq5LicrpY2fClyaI1j63o/I+rfK2QidsqsBW7vmZO/GumFTgM7p8BkxkkyeV0cffNrpeU+WDCKr R+w4FgJr/XBy5xE0apROP7q2p0kM= X-Google-Smtp-Source: AGHT+IHfhVo752mNxhDA0Pr0353FrPtk4Vwwq6eCh/SuQGB41PUesShMrJfDYj18T9ea2o5ffdq4OA== X-Received: by 2002:a05:600c:c8d:b0:43c:f1b8:16ad with SMTP id 5b1f17b1804b1-45334af6e5emr3399805e9.30.1749758826257; Thu, 12 Jun 2025 13:07:06 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:260:ea3b:b7db:9841:e1cf:f924]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4532e254396sm31485105e9.28.2025.06.12.13.07.05 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 12 Jun 2025 13:07:05 -0700 (PDT) Message-ID: <89c167ef628e5fa32ea0be433e61df8971e9641c.camel@cybertec.at> Subject: Re: pg_dump --with-* options From: Laurenz Albe To: Robert Haas , Jeff Davis Cc: Nathan Bossart , Peter Eisentraut , pgsql-hackers Date: Thu, 12 Jun 2025 22:07:05 +0200 In-Reply-To: References: <7cc52488-f876-4ad3-affd-6e4b0ef0cb09@eisentraut.org> <7bf0246542713d80f12c738c1d365d1365750c18.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-06-12 at 13:36 -0400, Robert Haas wrote: > On Thu, Jun 12, 2025 at 11:58=E2=80=AFAM Jeff Davis w= rote: > > On Thu, 2025-06-12 at 09:52 -0500, Nathan Bossart wrote: > > > If the idea is to remove all options for default behavior, we'd be > > > removing > > > --no-statistics, --with-data, and --with-schema at this point. > >=20 > > That's OK with me. >=20 > Same. 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 Yours, Laurenz Albe