Re: create tablespaces and users - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: create tablespaces and users
Date
Msg-id 298a21d9-c6b3-e80b-adf5-4583c9df2f70@gmx.net
Whole thread Raw
In response to create tablespaces and users  (Pepe TD Vo <pepevo@yahoo.com>)
Responses Re: create tablespaces and users  (Pepe TD Vo <pepevo@yahoo.com>)
List pgsql-admin
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





pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Delete Enhancement Request
Next
From: Kenneth Wong
Date:
Subject: pgAdmin 4 version 3.5 and 4.0 exist simultaneously