Feedback-ID: ic6394509:Fastmail
MIME-Version: 1.0
Date: Mon, 05 Aug 2024 14:04:08 +0200
From: "Joel Jacobson" <joel@compiler.org>
To: "Aleksander Alekseev" <aleksander@timescale.com>,
 pgsql-hackers <pgsql-hackers@postgresql.org>
Message-Id: <5859e123-2fb1-4160-8999-bc8bcf51fba0@app.fastmail.com>
In-Reply-To: 
 <CAJ7c6TO+QUYf7B3zBj+7Pf3ikEfOub0D-X7JnH1qJ2jvaXwAwg@mail.gmail.com>
References: <73b34bf6-d2d8-4eb9-acb6-5a8cdf11674b@app.fastmail.com>
 <CAJ7c6TO+QUYf7B3zBj+7Pf3ikEfOub0D-X7JnH1qJ2jvaXwAwg@mail.gmail.com>
Subject: Re: Is *fast* 32-bit support still important?
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/5859e123-2fb1-4160-8999-bc8bcf51fba0%40app.fastmail.com>
Precedence: bulk

On Tue, Jul 30, 2024, at 11:06, Aleksander Alekseev wrote:
> Hi Joel,
>
> Here are my two cents.
>
>> 1. Who are the current users of 32-bit PostgreSQL?
>
> Pretty much any embedded system that uses just a few GB of memory may
> win from using a 32-bit processor (not necessarily in terms of
> performance, maybe in terms of price). Think of WiFi-routers, smart
> TVs, 3D printers, etc.

Thanks for feedback!

Do we know of any such products or users?

I found an OS that runs on many 32-bit chips, FreeRTOS, that seems quite=
 popular.
Couldn't find anything about PostgreSQL and FreeRTOS though.
I've posted a question on their forum. [1]=C2=A0Let's wait and see if we=
 hear from any real user.

I see one i386 and i686 build farm animals runs Debian.
Perhaps it makes sense to try to reach out to the Debian community,
and see if they know of any PostgreSQL users on 32-bit?

> Generally speaking it's hard to give an exact answer due to lack of
> "telemetry" in PostgreSQL.

Could we add a text message that is displayed to a user,
when compiling PostgreSQL on a 32-bit platform?

*****
NOTICE: You are compiling PostgreSQL on a 32-bit platform.

We are interested in learning about your use case.
Please contact us with details about how you are using
PostgreSQL on this platform.

Thank you!

Contact: pgsql-hackers@postgresql.org
Subject: Report from 32-bit user
*****

/Joel