From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@lists.postgresql.org
Subject: Re: create tablespaces and users
Date: Tue, 15 Jan 2019 08:26:25 +0100
Message-ID: <298a21d9-c6b3-e80b-adf5-4583c9df2f70@gmx.net> (raw)
In-Reply-To: <858026322.18309717.1547479488317@mail.yahoo.com>
References: <858026322.18309717.1547479488317.ref@mail.yahoo.com>
<858026322.18309717.1547479488317@mail.yahoo.com>
Pepe TD Vo schrieb am 14.01.2019 um 16:24:
> From oracle databases, I have few tablespaces and users created for
> that particular database. How could I do the same for postgres?
The question is: what was the reason to use tablespaces in Oracle?
Most of the time I see an Oracle installation with a tablespace per user, it's to manage space more easily.
As Postgres does not store data in one huge file, this is not really relevant here.
As soon as a table is dropped, the space is released from the filesystem.
So just create the users and let them use the default tablespace, unless you used the tablespaces
to distribute the I/O load to different disks.
Thomas
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: pgsql-admin@postgresql.org
Cc: spam_eater@gmx.net, pgsql-admin@lists.postgresql.org
Subject: Re: create tablespaces and users
In-Reply-To: <298a21d9-c6b3-e80b-adf5-4583c9df2f70@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox