<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
ditto to Laurenz! We both must have written at the same time!
</div>
<div class="default-style">
<br>
</div>
<blockquote type="cite">
<div>
On 05/20/2022 10:13 AM Laurenz Albe <<a href="mailto:laurenz(dot)albe(at)cybertec(dot)at">laurenz(dot)albe(at)cybertec(dot)at</a>> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div>
On Fri, 2022-05-20 at 11:03 -0300, Daniel Bergmann wrote:
</div>
<blockquote type="cite">
<div>
Folks ! who can help, I'm migrating a sql server system that contains many databases
</div>
<div>
and that the queries in these make join between the databases, going to postgres I
</div>
<div>
create a database with only several schemas? or several databases using dblink to
</div>
<div>
do the joins? in case of a single database how can I manage the tablespaces?
</div>
<div>
per schema (1 schema in 1 tablespace) ?
</div>
</blockquote>
<div>
If you want to join the tables, use different schemas in a single database.
</div>
<div>
dblink or foreign data wrappers would just add additional complexity and
</div>
<div>
slow down operation.
</div>
<div>
<br>
</div>
<div>
Don't create any tablespaces, keep everything in the default tablespace.
</div>
<div>
<br>
</div>
<div>
Yours,
</div>
<div>
Laurenz Albe
</div>
<div>
--
</div>
<div>
Cybertec | <a href="https://www.cybertec-postgresql.com" rel="noopener" target="_blank">https://www.cybertec-postgresql.com</a>
</div>
</blockquote>
</body>
</html>