Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nEABe-00045v-0O for pgsql-general@arkaria.postgresql.org; Sun, 30 Jan 2022 13:24:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nEABc-0006qz-Qh for pgsql-general@arkaria.postgresql.org; Sun, 30 Jan 2022 13:24:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nEABc-0006qp-GM for pgsql-general@lists.postgresql.org; Sun, 30 Jan 2022 13:24:08 +0000 Received: from mail-pj1-x1029.google.com ([2607:f8b0:4864:20::1029]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nEABZ-0001po-Qm for pgsql-general@lists.postgresql.org; Sun, 30 Jan 2022 13:24:08 +0000 Received: by mail-pj1-x1029.google.com with SMTP id g15-20020a17090a67cf00b001b7d5b6bedaso1860699pjm.4 for ; Sun, 30 Jan 2022 05:24:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=n45cIE/u6yFXEko5E5X0RT0sBa9dN6nj9zUmlnRzJcM=; b=g5uXGhjWQt+z3NHTmkoOiztLXXHOfRnSRMVGNDbU1iW2nbTwlDKCAYnsGNFbR+BXTI 9BMKYXiOgY5qEP/3qz++NidFc5UMdx05sZsiUhvfbh15wX5+xWdizmqtm1VY5apuxkFh Is6wcTG2v60msaxmPO+AbJ2u4axiekMcCsLPimHiVarqsaO1xaklm9n2E1WjlKqjtOs+ I/Mp7rBLxz8buDbFkKCjwnb88nGTD7f2/lpCG8F4NPKdWxy8rh3jkoGmo69SCrYTNe8m JNK2+dVEf4QmJ8H0nDS0sEiqyDIs+Mlm6q/AZlo6FcwMjwtWlPcvMRlWow/ATVtHYE/d PZOg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=n45cIE/u6yFXEko5E5X0RT0sBa9dN6nj9zUmlnRzJcM=; b=JgQgOV+hm4DFE7Bjl0jfMltQF1MsE7rWnSRUtZnXuTzSinQMW03Lh9aw+QHSt8eV+m fhzBgSa6qe4Qmwly2SbkEhEiXGcUg7jYhcNr9h9Wo9kUrLOazkAASddj0ypMIrmGQA+U XC2F2R+kFM7T5vs1hLFHpgQ0YZnfv9HpqTUL2l54N5C0KxFHMi5EirCmyt1nK8lJZZC/ 8+fOYWmOM4ahfo7svM9IH2Zdi+vDE/8ro4WObgtWII/KpxpsBgOcE8FrcdnwxBOCfMKW nrba88HoSTsOk6VvZEA/DNpSrSDD5egiec5cJwVS2XqsjVRgTRjbt6NgoyDkrJbM0UGS bmoA== X-Gm-Message-State: AOAM5318JJbd/Xgc2ApPW73bgeA3v5zz9NA5yVAlPFoXfbfurE9JT/Rx sZufe4LEVba+bdAlNqJfV5k= X-Google-Smtp-Source: ABdhPJxWdQOw/NAU1/y1B5qlHIoA9GIhuYQSsysbcsY+JoTMynCtOI4lX+iJPHYY+2cEZV+8XBLjVw== X-Received: by 2002:a17:902:a404:: with SMTP id p4mr17222934plq.144.1643549043810; Sun, 30 Jan 2022 05:24:03 -0800 (PST) Received: from jrouhaud (2001-b011-1005-557a-1842-f511-47fe-bf4e.dynamic-ip6.hinet.net. [2001:b011:1005:557a:1842:f511:47fe:bf4e]) by smtp.gmail.com with ESMTPSA id v20sm14883790pfu.155.2022.01.30.05.24.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sun, 30 Jan 2022 05:24:03 -0800 (PST) Date: Sun, 30 Jan 2022 21:23:53 +0800 From: Julien Rouhaud To: Yudianto Prasetyo , pgsql-general@lists.postgresql.org Subject: Re: what is the solution like oracle DB's datafile Message-ID: <20220130132353.uncxuf75vo5bthhj@jrouhaud> References: <20220130131111.zlabglymewik3zfc@jrouhaud> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Please keep the list in copy and don't top post here: https://wiki.postgresql.org/wiki/Mailing_Lists#Email_etiquette_mechanics On Sun, Jan 30, 2022 at 08:18:15PM +0700, Yudianto Prasetyo wrote: > > what is the function of adding a new tablespace if we will only fill data > in table color and HDD1 is full? can't we fill the data in table color > because it still refers to the old tablespace ( small_data on HDD 1 not in > the new tablespace on HDD 2 ) You can move some of the tables and/or indexes on the new tablespace to free some space on the old one, see e.g.: - ALTER TABLE ... SET TABLESPACE: https://www.postgresql.org/docs/current/sql-altertable.html - ALTER INDEX ... SET TABLESPACE: https://www.postgresql.org/docs/current/sql-alterindex.html