Content-Type: multipart/alternative; boundary=Apple-Mail-9E9F1DF2-0FEC-4EC4-A070-649DB635DACA
Content-Transfer-Encoding: 7bit
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Quesion about querying distributed databases
Date: Wed, 5 Mar 2025 20:43:56 -0700
Message-Id: <025C57B4-F1C3-4533-86FD-D7C85EDCF143@gmail.com>
References: <CA+FnnTzjSDE9E=TF56F-EAp6u=oPH2vmGNrjN50H53dXrev1MA@mail.gmail.com>
Cc: me nefcanto <sn.1361@gmail.com>,
 Adrian Klaver <adrian.klaver@aklaver.com>,
 Laurenz Albe <laurenz.albe@cybertec.at>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
In-Reply-To: <CA+FnnTzjSDE9E=TF56F-EAp6u=oPH2vmGNrjN50H53dXrev1MA@mail.gmail.com>
To: Igor Korot <ikorot01@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/025C57B4-F1C3-4533-86FD-D7C85EDCF143%40gmail.com>
Precedence: bulk


--Apple-Mail-9E9F1DF2-0FEC-4EC4-A070-649DB635DACA
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable


> On Mar 5, 2025, at 8:03=E2=80=AFPM, Igor Korot jnit worked great for SQL S=
erver. If you're small, we host them all on one server. If you get bigger, w=
e can put heavy databases on separate machines.
>>=20
>> However, I don't have experience working with other types of database sca=
ling. I have used table partitioning, but I have never used sharding.
>>=20
>> Anyway, that's why I asked you guys. However, encouraging me to go back t=
o monolith without giving solutions on how to scale, is not helping. To be h=
onest, I'm somehow disappointed by how the most advanced open source databas=
e does not support cross-database querying just like how SQL Server does. Bu=
t if it doesn't, it doesn't. Our team should either drop it as a choice or f=
ind a way (by asking the experts who built it or use it) how to design based=
 on its features. That's why I'm asking.
>>=20

Cross-database on MSSQL is identical to cross schema on postgres. If you tru=
ly need cross server support (versus say beefier hardware) how did you come t=
o choose postgres?  The numbers you present are impressive but not unheard o=
f on this list.=20


--Apple-Mail-9E9F1DF2-0FEC-4EC4-A070-649DB635DACA
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"></div><div dir=3D"ltr"><br=
></div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Mar 5, 2025, at 8:0=
3=E2=80=AFPM, Igor Korot jn<span style=3D"font-family: tahoma, sans-serif;">=
it worked great for SQL Server. If you're small, we host them all on one ser=
ver. If you get bigger, we can put heavy databases on separate machines.</sp=
an></blockquote></div><blockquote type=3D"cite"><div dir=3D"ltr"><div dir=3D=
"auto"><div dir=3D"auto"><div class=3D"gmail_quote gmail_quote_container"><b=
lockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #=
ccc solid;padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_default" st=
yle=3D"font-family:tahoma,sans-serif"><br></div><div class=3D"gmail_default"=
 style=3D"font-family:tahoma,sans-serif">However, I don't have experience wo=
rking with other types of database scaling. I have used table partitioning, b=
ut I have never used sharding.</div><div class=3D"gmail_default" style=3D"fo=
nt-family:tahoma,sans-serif"><br></div><div class=3D"gmail_default" style=3D=
"font-family:tahoma,sans-serif">Anyway, that's why I asked you guys. However=
, encouraging me to go back to monolith without giving solutions on how to s=
cale, is not helping. To be honest, I'm somehow disappointed by how the most=
 advanced open source database does not support cross-database querying just=
 like how SQL Server does. But if it doesn't, it doesn't. Our team should ei=
ther drop it as a choice or find a way (by asking the experts who built it o=
r use it) how to design based on its features. That's why I'm asking.</div><=
div class=3D"gmail_default" style=3D"font-family:tahoma,sans-serif"><br></di=
v></div></blockquote></div></div></div></div></blockquote><div><br></div>Cro=
ss-database on MSSQL is identical to cross schema on postgres. If you truly n=
eed cross server support (versus say beefier hardware) how did you come to c=
hoose postgres? &nbsp;The numbers you present are impressive but not unheard=
 of on this list.&nbsp;<div><br></div></body></html>=

--Apple-Mail-9E9F1DF2-0FEC-4EC4-A070-649DB635DACA--