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.96)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1vn9YP-002zg4-1K
	for pgsql-admin@arkaria.postgresql.org;
	Tue, 03 Feb 2026 06:06:25 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1vn9YN-003Juj-2e
	for pgsql-admin@arkaria.postgresql.org;
	Tue, 03 Feb 2026 06:06:23 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1vn9YN-003Jub-1Q
	for pgsql-admin@lists.postgresql.org;
	Tue, 03 Feb 2026 06:06:23 +0000
Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1vn9YL-00000000J0y-0lrb
	for pgsql-admin@lists.postgresql.org;
	Tue, 03 Feb 2026 06:06:22 +0000
Received: by mail-wm1-x329.google.com with SMTP id
 5b1f17b1804b1-4806f80cac9so26730285e9.1
        for <pgsql-admin@lists.postgresql.org>;
 Mon, 02 Feb 2026 22:06:20 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec.at; s=google; t=1770098779; x=1770703579;
 darn=lists.postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=YokGjmxfdz3XE8rhNInVP8WkwLtNedkh0DkVHLpp1V8=;
        b=bW4sUF7zYs5vt9Ru3e1G+CM/qyYHUDBRr3UrHcF+rh/2JslmjRJAOIQdQpww9aChyD
         JH0E2LAFtxXByzHrmmyVZ84VXZfyE4oHT1aZe47e9spuoZL/O3sDYpSk8M/aEo2BZoIW
         eaBUqY7U+76nrVdOQWJTYGQC7VNySgYsaVejD1nNakK47zS/Xy6JCxAGcxPwieklaXih
         cCueiyQrP5r/gv7bYlI/JG/N2tm4WxCkH/0spA2pp4Z2D3Jt2J/Bwux6NB0tJhP8mGTB
         Lou4/uEx1XY4gwtHu9WeyNbFZ0k84jeVOzDrRLR6RhDmAlmF5tH3bypDY4JyhDgAN8nn
         o3vw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1770098779; x=1770703579;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:x-gm-gg
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=YokGjmxfdz3XE8rhNInVP8WkwLtNedkh0DkVHLpp1V8=;
        b=MWEKpTV80lSeL4gyaM19G5OpUjyRzetNGRZ7Cj9W5JdI41vEtzoZatZ1ET2wN175NK
         32oSDlJaWqoTnk1h4SMD9DHHBU3JZ9MVF6+qqUFCqOG9/NoVnZ/JXhmBHSNzhhjwlwLI
         Vwt62EcE8RZnXEvrB0ytwvEMX/oLejOtkMe89JLSipgTEYqEBebIyCEks6HsWgr2XmSN
         l714ZqkkSIhOPTC9Jke3y+T/oSgQ9aQ1Fb3hZ3bsZnwGxqL5yFA7Ail3Dt/dKvBS/BRS
         kLOGqIrsfLwU3agEdBqF5SMeuykEvwZIGMKUa/lPUbiBAhRdDdN9iWoLFRVGr4LZmxIb
         oQJQ==
X-Forwarded-Encrypted: i=1;
 AJvYcCWwwIZEsURwtKYHCBhS9MYdyo/hdGWogFshWfUHhDLbnchHhhX/Vp3ccFDF+ByS1BtVWsAKPJzhYFn4ng==@lists.postgresql.org
X-Gm-Message-State: AOJu0YzCy1OJ7xYenAVXQFnKfW8+tZEgGsfBsHe4bzGU9usL8WWeFCqb
	oX1xRPtZ3o4za5O3ULhdIin0Ovjwwat+ei6vb1pGPasbYZu2xbAHpjvQ3+TYcKw0N2gBbqlZoN6
	tSH5T
X-Gm-Gg: AZuq6aLWH2tpVfR8zaSK6AlZehKEtWLaMohIDynJzNzDWHELEj7PB9AoR6z+5u34IgB
	tkxdM4B+QNpxHPvKpWoMfFmEEDtLLe31/4Nd3ox9qVaeal15NEf9tU4JV6UsTGjIfOEVdQUbmjS
	um2ff36daikbI4ioB3xuXSamLFJbiIqlsj2LpH3quZ00CreNEhe41uLVia4OZPpwfO2ZgHgh2CG
	UePkdKtOGDhyNIOfAJkHHYsRBU6cPe013OBGVTskLHW2CkMrFX3Z7tjlLW3TErakgIYc8OsgWXy
	dZ9lCAw0OzuSHycWpowzbDBERHItvQjNQYtbDgjIMejdTeadaGyuH4lYsN+slD4QKcYRd0o7eBW
	mSPm2ZwAkAi24UjW82pxEMLnATTfxqv9bw+b9fPAkLnvoUaHRUzQVlT2HiwOFaknW9Oh9O20Ibx
	AV4nzOCutBZFVdUPyqsv+9ELoSq6W/yliejPd4q3/D3KTA6UjePBb4
X-Received: by 2002:a05:600c:1549:b0:471:114e:5894 with SMTP id
 5b1f17b1804b1-482db4e3054mr183952815e9.25.1770098779617;
        Mon, 02 Feb 2026 22:06:19 -0800 (PST)
Received: from laurenz.albe-K4N0CV00F97414D
 ([2001:871:260:83f9:a029:9851:8fa8:208b])
        by smtp.gmail.com with ESMTPSA id
 5b1f17b1804b1-4830513352csm38273895e9.10.2026.02.02.22.06.18
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 02 Feb 2026 22:06:19 -0800 (PST)
Message-ID: <e31d0f6daaef9a7ce7248f43bd1063d444b4e859.camel@cybertec.at>
Subject: Re: Does pg_dump custom format only compress the table data?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron Johnson <ronljohnsonjr@gmail.com>, Pgsql-admin
	 <pgsql-admin@lists.postgresql.org>
Date: Tue, 03 Feb 2026 07:06:18 +0100
In-Reply-To: 
 <CANzqJaAiTvMbuTUX86vZVCUY62KyHPffd_Dt1Po6Jmqv_9A_Bg@mail.gmail.com>
References: 
	<CANzqJaAiTvMbuTUX86vZVCUY62KyHPffd_Dt1Po6Jmqv_9A_Bg@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.2 (3.58.2-1.fc43) 
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/e31d0f6daaef9a7ce7248f43bd1063d444b4e859.camel%40cybertec.at>
Precedence: bulk

On Mon, 2026-02-02 at 10:55 -0500, Ron Johnson wrote:
> Out of curiosity, I opened that dump file in vim, and saw not only DDL st=
rings but cleartext table data.
>=20
> Why isn't it compressed?

Are your DDL statement large enough that you would expect that compressing
them would offer any real advantage?

Yours,
Laurenz Albe