Your message dated Sat, 29 Mar 2025 19:10:41 +0000
with message-id <[email protected]>
and subject line Bug#927182: fixed in postgresql-18
18~~devel.20250318+g4078da6c478-1
has caused the Debian Bug report #927182,
regarding Please split LLVM support into a separate, non-Depends package
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
927182: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=927182
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: postgresql-11
Version: 11~rc1-1
On most official platforms, postgresql-11 Depends on llvm70, used for
Just-in-Time Compilation:
https://www.postgresql.org/docs/current/jit.html
However, this has led to a 170% increase in package size - from ~5MB to
~13.5MB - due primarily to precompiled bitcode:
https://packages.debian.org/sid/postgresql-11#pdownload
Installed size almost doubles.
Then there's the runtime library, libllvm7, which is unlikely to be
installed (unlike libllvm3.9, which libstdc++6 relies on). It's another
~12.5MB, and expands to ~50-70MB.
You shouldn't have to install 100MB+ before you can use PostgreSQL.
Likewise, a ~400% increase in footprint is excessive for an optimization
with relatively small and variable benefits.
PostgreSQL does not seem to *require* these files, even if built
--with-jit. See:
https://github.com/postgres/postgres/blob/master/src/backend/jit/jit.c#L55
provider_init() checks the appropriate path and merely emits a log entry
once at DEBUG1 level if the provider isn't present (the same thing it does
if it is).
To me, it makes sense to place the default bitcode and llvmjit.so into a
separate binary package (postgresql-11-llvm?), depending on postgresql-11
and libllvm70, and make that package an enhance, suggests or *maybe*
recommends of postgresql-11 on platforms supporting it - rather than the
hard dependency it is currently.
The developers clearly had this in mind; they went out of their way to
provide "shared library separation":
https://github.com/postgres/postgres/blob/master/src/backend/jit/README
They even anticipated the use of Debian's optional dependencies:
https://www.postgresql.org/message-id/20180130220830.c6pn6j5lrdbbw7wu%40alap3.anarazel.de
> With things like apt recommends and such I don't think this is a huge
> problem. It'll be installed by default unless somebody is on a space
> constrained system and doesn't want that...
[I disagree that it should be installed by default, but it's a more
reasonable viewpoint than "must be installed"]
Don't get me wrong: JIT is a cool feature. I just think administrators
should be able to decide whether to install it, given the impact it has on
disk usage (and potentially memory usage, etc). Optional extension binary
packages also contain bitcode, but I don't suggest changing that, as the
size impact is far less.
Best regards,
--
Laurence "GreenReaper" Parry
https://www.greenreaper.co.uk/
--- End Message ---
--- Begin Message ---
Source: postgresql-18
Source-Version: 18~~devel.20250318+g4078da6c478-1
Done: Christoph Berg <[email protected]>
We believe that the bug you reported is fixed in the latest version of
postgresql-18, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Christoph Berg <[email protected]> (supplier of updated postgresql-18 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Tue, 18 Mar 2025 16:43:43 +0100
Source: postgresql-18
Binary: libecpg-compat3 libecpg-compat3-dbgsym libecpg-dev libecpg-dev-dbgsym
libecpg6 libecpg6-dbgsym libpgtypes3 libpgtypes3-dbgsym libpq-dev libpq5
libpq5-dbgsym postgresql-18 postgresql-18-dbgsym postgresql-18-jit
postgresql-18-jit-dbgsym postgresql-client-18 postgresql-client-18-dbgsym
postgresql-doc-18 postgresql-plperl-18 postgresql-plperl-18-dbgsym
postgresql-plpython3-18 postgresql-plpython3-18-dbgsym postgresql-pltcl-18
postgresql-pltcl-18-dbgsym postgresql-server-dev-18
postgresql-server-dev-18-dbgsym
Architecture: source amd64 all
Version: 18~~devel.20250318+g4078da6c478-1
Distribution: experimental
Urgency: medium
Maintainer: Debian PostgreSQL Maintainers <[email protected]>
Changed-By: Christoph Berg <[email protected]>
Description:
libecpg-compat3 - older version of run-time library for ECPG programs
libecpg-dev - development files for ECPG (Embedded PostgreSQL for C)
libecpg6 - run-time library for ECPG programs
libpgtypes3 - shared library libpgtypes for PostgreSQL 18
libpq-dev - header files for libpq5 (PostgreSQL library)
libpq5 - PostgreSQL C client library
postgresql-18 - The World's Most Advanced Open Source Relational Database
postgresql-18-jit - The World's Most Advanced Open Source Relational Database
postgresql-client-18 - front-end programs for PostgreSQL 18
postgresql-doc-18 - documentation for the PostgreSQL database management system
postgresql-plperl-18 - PL/Perl procedural language for PostgreSQL 18
postgresql-plpython3-18 - PL/Python 3 procedural language for PostgreSQL 18
postgresql-pltcl-18 - PL/Tcl procedural language for PostgreSQL 18
postgresql-server-dev-18 - development files for PostgreSQL 18 server-side
programming
Closes: 927182
Changes:
postgresql-18 (18~~devel.20250318+g4078da6c478-1) experimental; urgency=medium
.
* New major upstream version 18; packaging based on postgresql-17.
* Move JIT to new postgresql-18-jit package. (Closes: #927182)
Checksums-Sha1:
f60e96b0220525101804e72db4724b517e740757 4495
postgresql-18_18~~devel.20250318+g4078da6c478-1.dsc
e0d93125e59499e651026374188cd8235bd1ec7f 28841568
postgresql-18_18~~devel.20250318+g4078da6c478.orig.tar.gz
625519078d637b646998f1f3c3e6faf2ab0fdd99 24396
postgresql-18_18~~devel.20250318+g4078da6c478-1.debian.tar.xz
fa48dfc85046c01401c869d2e54cb60f7e39b474 16568
libecpg-compat3-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
c4fe4fad2be10e9437f742e7f466bc4551f3f25f 12016
libecpg-compat3_18~~devel.20250318+g4078da6c478-1_amd64.deb
6c1c239e30a797544723ef0a93e3a17d8a24b48d 172040
libecpg-dev-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
7420a80d4c644c2013d7a56a41332106b9e0fe1c 257776
libecpg-dev_18~~devel.20250318+g4078da6c478-1_amd64.deb
97c08bef7ad1ba44732d7333e2aeb3ea9022f35a 114056
libecpg6-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
fa9ca77ea0a24abca0a8c8e3ac33a6c78db21f52 57028
libecpg6_18~~devel.20250318+g4078da6c478-1_amd64.deb
6d795a8b28d08f47986381ac4ae5e52d8b436ae7 90896
libpgtypes3-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
1d7f288802bde1fc1fc76082d0b55d7e89a1d337 40540
libpgtypes3_18~~devel.20250318+g4078da6c478-1_amd64.deb
27e94a7dad8ed7d52909d825893ee05303e0754c 159828
libpq-dev_18~~devel.20250318+g4078da6c478-1_amd64.deb
3c0bea7b15d7c4c1d718ea84657a9ecaa9c3ae0c 363784
libpq5-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
13d7d0fdcfb3ba3cc27ac718bfab591e66b544d3 236860
libpq5_18~~devel.20250318+g4078da6c478-1_amd64.deb
f2d33c848239eb50630d9b806713fc0bc2605f2a 19247840
postgresql-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
1281e2dc93e00812bcf4536c6cf082d3d12cd48e 1305372
postgresql-18-jit-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
82467bb37fffe11bf2e462c9c80014d39a9a48ec 9748260
postgresql-18-jit_18~~devel.20250318+g4078da6c478-1_amd64.deb
9f6f3e68f73164f4c111092886cf5b6fc56a21c4 20821
postgresql-18_18~~devel.20250318+g4078da6c478-1_amd64.buildinfo
ed1b8e52784b0f94c3e651707192d20cb09e8a54 7059736
postgresql-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
9e42b390da786eb774938f48a4b08f1a490383f2 3100720
postgresql-client-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
c69a8fb459de88a989525e3e715ecda7a6147548 2031716
postgresql-client-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
70e49ecd5742b1680b83da52b4385f4531d72b10 2136624
postgresql-doc-18_18~~devel.20250318+g4078da6c478-1_all.deb
1ae42844bc563a7fef23102ec9a9ff79f51398b0 206056
postgresql-plperl-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
8aedcf7a6081214fd3316038399beb8b9b0f57b0 65076
postgresql-plperl-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
7673e807f07484614f5551774c4647bca0c954f0 184860
postgresql-plpython3-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
7f3dc616156b50957034cc841e7edd19667bce7e 89080
postgresql-plpython3-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
4777f5e2df602d4d17c8fe1631e58dc26dc08c95 89040
postgresql-pltcl-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
d26913670fe546e8e264e992316a459769787fbb 38304
postgresql-pltcl-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
dc2839a7d6a75363c37346b4fab6eebfe0142a56 56084
postgresql-server-dev-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
5af7e99ca5bb95d5d9c90f0abed55d2b8b14e501 1363236
postgresql-server-dev-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
Checksums-Sha256:
f79fd919157203b1725e160c0ac593f2011dfd8a9fb92214d1459a053b3cf369 4495
postgresql-18_18~~devel.20250318+g4078da6c478-1.dsc
7ee8f5aa0a72c13e4a241ae9a7e145ade5bb2cb3d45e7a58d37d38c7d74cc3f3 28841568
postgresql-18_18~~devel.20250318+g4078da6c478.orig.tar.gz
cd3b006696da7801b34083c300257944242047eebf12294d8b28e53cf7b0afd0 24396
postgresql-18_18~~devel.20250318+g4078da6c478-1.debian.tar.xz
b9a62b171e486a80800027733375d5c08eca8ba7baa1efaba6ba9c00038404e2 16568
libecpg-compat3-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
f8153ada81c2ab62eb5d18e45325be76b7313333bd9177a6362f26f590c5af2b 12016
libecpg-compat3_18~~devel.20250318+g4078da6c478-1_amd64.deb
c3461d1512ac9688bab34052f84a4da24b0f36672c3031b65d24616ec3296cd9 172040
libecpg-dev-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
64fcc06e5739d3461a7f8584f601c77f666fd8d703adaf922250ed3aa0411d5b 257776
libecpg-dev_18~~devel.20250318+g4078da6c478-1_amd64.deb
45b1fd992e935e4eb81ac330387418208d4e9d08303a2f60dbff117f922ae2e4 114056
libecpg6-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
be02149f4391cdf4e75fc8aa6a4f207aa9c8458488c3e1a4f4b4b6887ef16594 57028
libecpg6_18~~devel.20250318+g4078da6c478-1_amd64.deb
650696ad8ace9af3f7cf84ab7b96d81db151cad23d1f6c98dc8698d5ed60ca24 90896
libpgtypes3-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
d0dfc829e11818401f375ebd025543c7b21b0a7fe6be174748183247b2b5b0a7 40540
libpgtypes3_18~~devel.20250318+g4078da6c478-1_amd64.deb
676c77394937c573d911f5baa9cb1bcb237ab5ffcb5a052a40758bfc3283dd19 159828
libpq-dev_18~~devel.20250318+g4078da6c478-1_amd64.deb
50534eec4c06755769a25125024f585a13825572e6bf5393a48885de4ce2d59e 363784
libpq5-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
ff7f850eda832c2fdf675a8117b3b732daee3c0dd90201da8b51788bd499a453 236860
libpq5_18~~devel.20250318+g4078da6c478-1_amd64.deb
38a673f26c0886a9c8677ecf707abe89299c7ded8a3b51e63408912cfc24a2d3 19247840
postgresql-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
2521f3b7839aa85560ae53f1b10ee6275b12ef58ad1d8bff1644204da7e9100e 1305372
postgresql-18-jit-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
60b561658baa887ce1f22da02e0e74dbd6060a432f2913c1b852817dbe9bf903 9748260
postgresql-18-jit_18~~devel.20250318+g4078da6c478-1_amd64.deb
3ec38c1deec4b5377683d15830aed657cefb48e5dec2fbde2b2e8916ba3ff60b 20821
postgresql-18_18~~devel.20250318+g4078da6c478-1_amd64.buildinfo
fd39480c23dee8da8ff2b5daa7d0e7ca856b57a654b3b5cdf678e497cf6eb8c6 7059736
postgresql-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
898de4a5ae294f287824c208779a32cd35c7ec0fb01e314e131b36526a1713c5 3100720
postgresql-client-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
77542c86d038b9481db5de84b2224e966eea4527fe1ebe8ca84e53a53126504d 2031716
postgresql-client-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
4377645030f3fd42a21b6311a5373751fc87dda213f9b4629eb376b0073e7cf9 2136624
postgresql-doc-18_18~~devel.20250318+g4078da6c478-1_all.deb
87b85d990454b9b0dcb073b091fb8bd0b07b046f966aecbf0e471b35634a3cd8 206056
postgresql-plperl-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
329c93c8f83e2344491f6ad91cd6392889de3a62044327229fe731c303b22be4 65076
postgresql-plperl-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
d1613d95af4f5e653189315a44d6cc78d10eed9935fee8f5d6bcbc760e6d85b3 184860
postgresql-plpython3-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
57fdeeb985c511e1f271f33ab22efa8349d3b5b2c790419ed2fbaf6c6098bb29 89080
postgresql-plpython3-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
b67d477697d4e244be0eea982eb3a4f506346b03cd1f31dda3b9bb6196da0211 89040
postgresql-pltcl-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
4e829354820378eb436ab560e88393db66a55e8fb7308ff8f5bd36034a54da0c 38304
postgresql-pltcl-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
8cfd5cd08c6f34f716ea3a1534b9bcdef2208bc7e9249e8d47a5278561bba8b8 56084
postgresql-server-dev-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
f06d0d46bb032a342bcf352359a7953f542cc55aca19b615a524c8a2947f292e 1363236
postgresql-server-dev-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
Files:
b0164e6d9e133d77a7204d67f8537df2 4495 database optional
postgresql-18_18~~devel.20250318+g4078da6c478-1.dsc
d889b5c6e9d592da20b5f6fb9f712ec5 28841568 database optional
postgresql-18_18~~devel.20250318+g4078da6c478.orig.tar.gz
2939cb9df01781f3ca0a7e25f19db21c 24396 database optional
postgresql-18_18~~devel.20250318+g4078da6c478-1.debian.tar.xz
a7aae8ef47ffc5d47685c2e0a90ab383 16568 debug optional
libecpg-compat3-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
2f732f879d1ba06d8b1100731d3394ff 12016 libs optional
libecpg-compat3_18~~devel.20250318+g4078da6c478-1_amd64.deb
5e43908b964fe693a274b288fdf0f479 172040 debug optional
libecpg-dev-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
cf137650c91cc47c3f01c418355fb990 257776 libdevel optional
libecpg-dev_18~~devel.20250318+g4078da6c478-1_amd64.deb
e9dbda722e711fa691acc36c896efc66 114056 debug optional
libecpg6-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
022275b69d589fa93d7a9e9db36faed1 57028 libs optional
libecpg6_18~~devel.20250318+g4078da6c478-1_amd64.deb
837f0c9d07f0cd90ef03a8bada4c820a 90896 debug optional
libpgtypes3-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
8ba624ecdc51518ca5abae1b3cf0572d 40540 libs optional
libpgtypes3_18~~devel.20250318+g4078da6c478-1_amd64.deb
429da39b387a987b3da4f8ba64ab0115 159828 libdevel optional
libpq-dev_18~~devel.20250318+g4078da6c478-1_amd64.deb
780678eed225e8bff0b806e35074f044 363784 debug optional
libpq5-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
a91ec3f193f0ec6c75ec5b52d262c843 236860 libs optional
libpq5_18~~devel.20250318+g4078da6c478-1_amd64.deb
1cd4ec3b5153cf75a4d276d338ee9b2d 19247840 debug optional
postgresql-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
a98a92255ff0c69d100fee3970165720 1305372 debug optional
postgresql-18-jit-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
789ad1cf54cf08f62340a2f2b0e71731 9748260 database optional
postgresql-18-jit_18~~devel.20250318+g4078da6c478-1_amd64.deb
a53f090432ec016b399392ad279c46c3 20821 database optional
postgresql-18_18~~devel.20250318+g4078da6c478-1_amd64.buildinfo
ba8b4daec7a9ecb75066652695092021 7059736 database optional
postgresql-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
064608d6ed81b1105639523e73c3f7dd 3100720 debug optional
postgresql-client-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
970165a064646fb76850b708ee48df2b 2031716 database optional
postgresql-client-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
93e889bee2ccc64d9a4743967e1fd0f5 2136624 doc optional
postgresql-doc-18_18~~devel.20250318+g4078da6c478-1_all.deb
3bafb98dd0fd1920a159671e009833f9 206056 debug optional
postgresql-plperl-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
bf0de0045f6fae13a22bc9466242a04c 65076 database optional
postgresql-plperl-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
1c7fd7c00664c61a1ddea61729d7a8a5 184860 debug optional
postgresql-plpython3-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
a9264096c09172f906ef20d74d800c2c 89080 database optional
postgresql-plpython3-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
43cc537428a8888921d86dcb07c5182b 89040 debug optional
postgresql-pltcl-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
83f838ec942c554136dfb25b4f9ada05 38304 database optional
postgresql-pltcl-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
77f3eb67af2c8ce68b770f6525aa62fc 56084 debug optional
postgresql-server-dev-18-dbgsym_18~~devel.20250318+g4078da6c478-1_amd64.deb
7988cbb67cf2c53e7d85a43f63248ffd 1363236 libdevel optional
postgresql-server-dev-18_18~~devel.20250318+g4078da6c478-1_amd64.deb
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEXEj+YVf0kXlZcIfGTFprqxLSp64FAmfZnJoACgkQTFprqxLS
p65OFxAAkPuJ3EfMqTvHo7yMT8GtjtPbUOIZ+T3+tj7tHUXFRptPV6Mx7/eUe63U
OCI7QaWqdP9hq+aFkGTzsq5Pa4ZeCBESMrAZEoMhWU7CMLIp6FtEA3GXi2PuN4IP
+Sc2wF/j5YtKaUeO9tRMCHyDOFADSWGAofbOnxx1Zx0zuAlYOTk281lh3tY3rvXq
Or+WsEK4bSSUVS4Iz+EHXJIC89meQvBuyPePCXv6x/qLE1ejG2W0zzEQoPjgRz1o
Jh+WcZd+Tc8+HiAxKbyFZpXliBngmYENvsv5vywPVOYypyRJoT8dY4fIXFULcRGl
UBBmgGggrLpBkxjcYqAMKWrN6BCFh3CmGM9WYjQcOd3JpklGZ39jLaHoo1SV53be
2JC6VkhSYnheVsU7qPkCJRKWGNWdC3L7ryBxB8Bo+fERfjV2X53Bn1iF+3+nPMbk
vw5cAYl/TVf5iSoMbJxpgaCPPISDuLlfYyDdDCFuRsRASPF4d8W8/C6RFAtBse45
DZ3gDFRS/N2U0ulF1QEXc7MiuUUicXiYFPi4/PhSR+eNRoMLBpJQqU93M2/3iZ46
d3QKpsmaPJzPFQUDQ0RMceqgSl1T4MmZckoLX3A/9m4pOpR8F7Kl6EkXRRtnsBOP
hvCi11wADrzjFjfSww6gpuarbjVZjGlXCAzB9M9wLS4Xf8/pUOc=
=+kJJ
-----END PGP SIGNATURE-----
pgpUFgYUET5q8.pgp
Description: PGP signature
--- End Message ---
