| From: | me nefcanto <sn(dot)1361(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Quesion about querying distributed databases |
| Date: | 2025-03-05 10:48:20 |
| Message-ID: | CAEHBEOBNoG8RkKuCcQQWkbYppMLMzA0MXq+s0kZ6wKWgD7+45Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear Laurenz,
That means a solid monolith database. We lose many goodies with that. As a
real-world example, right now we can import a single database from the
production to the development to test and troubleshoot data.
What if we host all databases on the same server and use FDW. What happens
in that case? Does it return 100 thousand records and join in the memory?
Because in SQL Server, when you perform a cross-database query (not
cross-server) the performance is extremely good, proving that it does not
return 100 thousand ItemId from Taxonomy.ItemCategories to join with
ProductId.
Is that the same case with Postgres too, If databases are located on one
server?
Regards
Saeed
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-03-05 11:48:23 | Re: Quesion about querying distributed databases |
| Previous Message | Laurenz Albe | 2025-03-05 09:55:01 | Re: Quesion about querying distributed databases |