Search Postgresql Archives

Re: Oracle vs. PostgreSQL - a comment

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Jun 2, 2020, at 12:45 , Ravi Krishna <sravikrishna@xxxxxxxxxxx> wrote:



Generally speaking, I discourage having lots of databases under one PG
cluster for exactly these kinds of reasons.  PG's individual clusters
are relatively lightweight, after all.


Plus PG does not directly support cross database queries using 3 part name, something
sqlserver excels at.

Gotta say, not generally a fan of SQL Server, but this is very nice. If I’m dealing with a database with 50 small databases on it, it’s an utter pain to have to set up fdw connections between every set of databases I want to use together.

Any chance of getting this in Postgres? Seems like since the databases are in the same program, this ought to be simpler.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux