Date: Sat, 25 Oct 2025 17:31:30 +0200
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: Download statistics
Message-ID: <ctmaj2duonkjuln7xmzelykmgpuu37rl5yrzmvcowcv65qrfla@o6avneihp4fd>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <7pwwv34tsim6ehsu4bosy3ol7ctmf2blig6rgwo7kq5ilaidua@miqogysnbey7>
 <1971494.1761403114@sss.pgh.pa.us>
 <CANzqJaBfJWDfaUZqa9iU-hk5xFiob+tjFZH-QdoF+xGd3B5kOA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="c7b45cdlojwwnkrq"
Content-Disposition: inline
In-Reply-To: <CANzqJaBfJWDfaUZqa9iU-hk5xFiob+tjFZH-QdoF+xGd3B5kOA@mail.gmail.com>
Archived-At: <https://www.postgresql.org/message-id/ctmaj2duonkjuln7xmzelykmgpuu37rl5yrzmvcowcv65qrfla%40o6avneihp4fd>
Precedence: bulk


--c7b45cdlojwwnkrq
Content-Type: text/plain; protected-headers=v1; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Subject: Re: Download statistics
MIME-Version: 1.0

On 2025-10-25 10:43:41 -0400, Ron Johnson wrote:
> On Sat, Oct 25, 2025 at 10:38=E2=80=AFAM Tom Lane <tgl@sss.pgh.pa.us> wro=
te:
>=20
>     "Peter J. Holzer" <hjp-pgsql@hjp.at> writes:
>     > The discussion about people avoiding .0 releases over in the "Index
>     > corruption ..." thread made me wonder how the distribution really l=
ooks
>     > like. How many people do install X.0, X.1, etc. for each major vers=
ion
>     > X?
>=20
>     > Download statistics are of course quite noisy but I think they shou=
ld at
>     > least show the trends. Do you have any and would you mind publishing
>     > them?
>=20
>     I imagine we have stats for downloads from www.postgresql.org,
>     but it's been many years since we thought those were complete
>     or even representative.
>=20
>=20
> I download one set of RPMs (PG 14.19, for example) and then scp them to 15
> different servers.=C2=A0 One set of PG 17.6 binaries gets copied to 30 di=
fferent
> servers.

Yes, these are both examples of what I meant by "noisy". There
are other sources than www.postgresql.org (and apt.postgresql.org,
download.postgresql.org, etc.) and one download may be used for many
installations or sometimes none. So the absolute numbers are almost
meaningless. However, the trends might still be illuminating. Of course
the patterns might be totally different for those users who just use
whatever is included with their Linux distribution (for example the 2
year release cycle of Debian and Ubuntu would cause some shifts) but
I'm not convinced it would be that different.

        hjp

--=20
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

--c7b45cdlojwwnkrq
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmj87UsACgkQ8g5IURL+
KF1Ldw/+OtzAkA0ebW4ZxIyNuvc1UJOTEXj2O2N0xzgf3zaJTvHCn2FJGw8HTgnJ
h7GlycBe8MbCZd517dMbDLtyUA5GIenvG0LfP1zvO/YO4kiMpjAbROo6ajwaoKGG
/svjlGnRKkEoouoD6MPOxCXev+65tIukeZ9AqqgYXTjaoNjKWfUCodeVgzcMQKQc
jGistnLnNrY/HdkgJSJHSoh7meaiYaRUJI9NlVMNkInLbhSAd009zQPtIeCxOMvA
TeL9SSkpq37SlVBcONosYLaaDmTPxiOoQlOfCMuj77Q41L4Sug0rjAR43ibFrZ6/
4DLDQTFu5f0CJOTOY/6OT+x4Wh2kFqxWdmvAqjNOjX8bCoIu7JOlAfNdaEgldVuM
Bs3qMzZsF1nu9/IBmhRYlfMvifh+3Df2vIFrg96Td0nVcUj7XM0UX7BkLq7sY0Gr
VF+p/+XpIIeX1hEyvWZrcXSTNfLBqkMl5M1XGtdG+S28ZD2J4z9iOrlvLjG0zr4T
YQ0YlleanvvRif4tceuQLmtHpeqzc6LPMHKk71Q14SlFutljwhD9/d7pROW8aLXH
Y4mWleRkesS6R7d1XQXn25D8UWJ0riGdZQC4f4mVU0W7KCaDSHKUuemklBvxKG5p
nX4tg8td7lSnF/pyULxCNRNRJ7U4xg6hO42Gtg0NBXnCeJMxBFE=
=DSkm
-----END PGP SIGNATURE-----

--c7b45cdlojwwnkrq--