Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle vs. PostgreSQL - a comment - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: Oracle vs. PostgreSQL - a comment
Date
Msg-id c741e0c1-507c-9ac9-aa1f-53ce00e43188@matrix.gatewaynet.com
Whole thread Raw
In response to Re: Oracle vs. PostgreSQL - a comment  (Ravi Krishna <sravikrishna@comcast.net>)
Responses Re: Oracle vs. PostgreSQL - a comment  (Ravi Krishna <srkrishna@outlook.com>)
Re: Oracle vs. PostgreSQL - a comment  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
Tree view 
On 2/6/20 10:45 μ.μ., Ravi Krishna 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.
Maybe because SQL server does not have real databases but schemas instead ?
This sucks security wise.
>
>
>
>


-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt

pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: Potential optimisation for the creation of a partial indexcondition over a newly created nullable, non-default-valued column?
Next
From: Ravi Krishna
Date:
Subject: Re: Oracle vs. PostgreSQL - a comment