Hi Daniel,

My preference would be to create multiple schemas in one database and avoid the headache of using dblink/postgres_fdw to communicate back and forth. Regarding tablespaces, no need to do anything special there, just use the default tablespace that all objects go into. In PG, tablespaces only have importance when mapping them to different mount points that might have different IO response times.

Regards,

Michael Vitale

On 05/20/2022 10:03 AM Daniel Bergmann <dcberg@gmail.com> wrote:

Folks ! who can help, I'm migrating a sql server system that contains many databases and that the queries in these make join between the databases, going to postgres I create a database with only several schemas? or several databases using dblink to do the joins? in case of a single database how can I manage the tablespaces? per schema (1 schema in 1 tablespace) ?

Thanks,

Daniel