public inbox for [email protected]
help / color / mirror / Atom feedFrom: MichaelDBA Vitale <[email protected]>
To: Daniel Bergmann <[email protected]>
To: [email protected]
Subject: Re: Many databases ou many schemas
Date: Fri, 20 May 2022 10:15:42 -0400 (EDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAPzke6VtMw4aJXDFecDJtVPR9BPyG6mzmFy-y2bqo92xS26DZw@mail.gmail.com>
References: <CAPzke6VtMw4aJXDFecDJtVPR9BPyG6mzmFy-y2bqo92xS26DZw@mail.gmail.com>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
Hi Daniel,
</div>
<div class="default-style">
<br>
</div>
<div class="default-style">
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.
</div>
<div class="default-style">
<br>
</div>
<div class="default-style">
Regards,
</div>
<div class="default-style">
Michael Vitale
</div>
<blockquote type="cite">
<div>
On 05/20/2022 10:03 AM Daniel Bergmann <[email protected]> wrote:
</div>
<div>
<br>
</div>
<div>
<br>
</div>
<div dir="ltr">
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) ?
<br>
<div>
<br>
</div>
<div>
Thanks,
</div>
<div>
Daniel
</div>
</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]
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