MIME-Version: 1.0
From: Alexander Farber <alexander.farber@gmail.com>
Date: Sat, 22 Feb 2025 19:58:07 +0100
Message-ID: <CAADeyWiRpyaqUMP5sJR971fUj65WX1CEjHVmg12KvsgUe7vFsg@mail.gmail.com>
Subject: Azure Database for PostgreSQL flexible server vs other Azure offerings
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ae81d5062ebfb0e5"
Archived-At: <https://www.postgresql.org/message-id/CAADeyWiRpyaqUMP5sJR971fUj65WX1CEjHVmg12KvsgUe7vFsg%40mail.gmail.com>
Precedence: bulk

--000000000000ae81d5062ebfb0e5
Content-Type: text/plain; charset="UTF-8"

Good evening,

I am trying to convince my team (a small team at a big company) to move
from Azure Redis E10 to PostgreSQL, because I am tired of seeing how we
(poorly) try to re-invent an SQL database using Redis.

My problem is that the team does not want and I am the only one liking SQL
databases and especially PostgreSQL (using it for hobby projects since
version 8, always a single instance with a pg_bouncer).

I have spent 3 weeks including my weekends and prepared a PoC currently
using 2 official PostgreSQL docker hub images in our AKS, but that setup
looks toyish vs the expensive managed Redis E10.

I would like to switch to the most official and supported Azure offering
(and the money kind of does not matter), but a bit confused by the 3
Microsoft offerings I see:

- https://azure.microsoft.com/en-us/products/postgresql "Azure Database for
PostgreSQL" - this one scares me be talking about AI that we do not need.
Also it looks more like some abstract product or is it a real setup?

- "Azure Database for PostgreSQL Single Server" - I would take that, but it
is obsolete/deprecated?

- "Azure Database for PostgreSQL Flexible Server" - Looks like I have to
take this one, but I do not want all the replication/zones features,
because I have no experience there and we already have had enough headache
with Redis Enterprise and some hashes not being saved because they are on
different shards etc.

Our setup: we need 2 databases with 3 and with 6 tables and few stored
procedures and at the beginning they do not even to be permanent (it is ok
to be empty on the pipeline deployment). Max 100 client connections. It
would be nice to be able to scale up / scale down.

So my question is: who is using what for PostgreSQL on Azure and how
happy/unhappy are you with your product?

Best regards
Alex

--000000000000ae81d5062ebfb0e5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di=
r=3D"ltr"><div dir=3D"ltr">Good evening,<div><br></div><div>I am trying to =
convince my team (a small team at a big company) to move from Azure Redis E=
10 to PostgreSQL, because I am tired of seeing how we (poorly) try to re-in=
vent an SQL database using Redis.</div><div><br></div><div>My problem is th=
at the team does not want and I am the only one liking SQL databases and es=
pecially PostgreSQL (using it for hobby projects since version 8, always a =
single instance with a pg_bouncer).</div><div><br></div><div>I have spent 3=
 weeks including my weekends and prepared a PoC currently using 2 official =
PostgreSQL docker hub images in our AKS, but that setup looks toyish vs the=
 expensive managed Redis E10.</div><div><br></div><div>I would like to swit=
ch to the most official and supported Azure offering (and the money kind of=
 does not matter), but a bit confused by the 3 Microsoft offerings I see:<b=
r><br>-=C2=A0<a href=3D"https://azure.microsoft.com/en-us/products/postgres=
ql">https://azure.microsoft.com/en-us/products/postgresql</a> &quot;Azure D=
atabase for PostgreSQL&quot; - this one scares me be talking about AI that =
we do not need. Also it looks more like some abstract product or is it a re=
al setup?</div><div><br></div><div>- &quot;Azure Database for PostgreSQL Si=
ngle Server&quot; - I would take that, but it is obsolete/deprecated?<br><b=
r>- &quot;Azure Database for PostgreSQL Flexible Server&quot; - Looks like =
I have to take this one, but I do not want all the replication/zones featur=
es, because I have no experience there and we already have had enough heada=
che with Redis Enterprise and some hashes not being saved because they are =
on different shards etc.<br><br>Our setup: we need 2 databases with 3 and w=
ith 6 tables and few stored procedures and at the beginning they do not eve=
n to be permanent (it is ok to be empty on the pipeline deployment). Max 10=
0 client connections. It would be nice to be able to scale up / scale down.=
<br><br>So my question is: who is using what for PostgreSQL on Azure and ho=
w happy/unhappy are you with your product?</div><div><br></div><div>Best re=
gards</div><div>Alex</div></div></div></div></div></div></div>

--000000000000ae81d5062ebfb0e5--