Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjJ7J-0007v0-IQ for pgsql-admin@arkaria.postgresql.org; Tue, 15 Jan 2019 07:26:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gjJ7G-0001qv-QJ for pgsql-admin@arkaria.postgresql.org; Tue, 15 Jan 2019 07:26:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjJ7G-0001qo-IV for pgsql-admin@lists.postgresql.org; Tue, 15 Jan 2019 07:26:30 +0000 Received: from mout.kundenserver.de ([212.227.17.24]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gjJ7E-0007W7-E1 for pgsql-admin@lists.postgresql.org; Tue, 15 Jan 2019 07:26:30 +0000 Received: from [10.8.0.101] ([185.40.248.10]) by mrelayeu.kundenserver.de (mreue109 [212.227.15.145]) with ESMTPSA (Nemesis) id 1MlwBh-1h9sI528ZP-00j3YA for ; Tue, 15 Jan 2019 08:26:26 +0100 Subject: Re: create tablespaces and users To: pgsql-admin@lists.postgresql.org References: <858026322.18309717.1547479488317.ref@mail.yahoo.com> <858026322.18309717.1547479488317@mail.yahoo.com> From: Thomas Kellerer Message-ID: <298a21d9-c6b3-e80b-adf5-4583c9df2f70@gmx.net> Date: Tue, 15 Jan 2019 08:26:25 +0100 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: <858026322.18309717.1547479488317@mail.yahoo.com> Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:xRY/FiCq4R2t57Aiuz3KLURz2Sw4L8hoHxQQSBB55OrB5E1FAH4 qSPU+Kwwc0HrJ5UUeSYqz9JgDoDd43o5muMMgzwT6abx6rtmyzzlPvebOfuYLwfUpiIkFoy DMxg4zo7BvbcP1KHxPeS1AxFubRIyqidkbBGiwZHrDi1oEGHjajDT6UnIZNkGERtWRQIt2A uDa7CHOxmRmsY4BVKEbFw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:yOel1kK9n8Q=:OZ+psUay9CuJdVklRqs0mv M396MthR/PYJ0sFIAKQrV7HxVbQ0AW7euLObIzjEAV1c5bngewMA9JCZ+g1lSEvKgV9gZ5s2L V/GBtatchVIZC1DBr9TC/rIw7YEf/S/Xaq4BRhQXWQ0nfQFCYhVwkg0Y0MTZedIzh/qgCEDVb DIAQ5l5MZ0/3zEgXjQbq99eXvibN8W+detH2wDHZYS/VieXkBHv7VndIRorHU3c47ToJoj6jj FLLxPSy5u2O0+yCWjtubtERdVK08tI5K110+ItgJN/yufOgdyePVdna++/bdj5Bg//ihwPk+y igLn7cFWCVFIe+HkrTcM23LOcvz6DgUTKSWEDmGxYwnTk9wt9hbmEj11MGuSEsOOvcsXw/1L9 vSdnwWigJ+JTFFEY8E8R1/gg7W/MGSJXxUWsHm20zc4EITI9dEc7HQD8WqzLGZq6b1UwE9iRW l1Wi0GKRjiu+okIUAleH3aIjU2uSskek0YH0DRGLF+aHNKjCtNYfchUArJ7S2ygT0olT8zc+q ufaBUJckYefD6/wle2VBkbOoRbILJw8gU2YTR6BgM4e4OJBRce7HBsGeQ94+bSpHG1Q4cogVc +ncZAYyBZN4CRl1Fi87Mleur5WuZEekDMyaDql5GvmcjY+xuf5L9qpreB5ZasMH5us5iMz69h KB/hX+WlCit1GSy1fnWoum+mdIUogSe8guvbELxRuexwNRawtAM70MiO0oYHGb4FZ6DZFZmao iPvV1XXjDC0qEmSUTC81I3jcJV9UFTddupyGjgeFPztwKBWZJPkMQkXQvlU= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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