public inbox for [email protected]
help / color / mirror / Atom feedFrom: MichaelDBA Vitale <[email protected]>
To: Laurenz Albe <[email protected]>
To: Daniel Bergmann <[email protected]>
To: [email protected]
Subject: Re: Many databases ou many schemas
Date: Fri, 20 May 2022 10:16:22 -0400 (EDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAPzke6VtMw4aJXDFecDJtVPR9BPyG6mzmFy-y2bqo92xS26DZw@mail.gmail.com>
<[email protected]>
<!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:[email protected]">[email protected]</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>
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Many databases ou many schemas
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox