pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Julien Rouhaud <rjuju123@gmail.com>
To: Yudianto Prasetyo <mr.yudianto@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: what is the solution like oracle DB's datafile
Date: Sun, 30 Jan 2022 21:23:53 +0800
Message-ID: <20220130132353.uncxuf75vo5bthhj@jrouhaud> (raw)
In-Reply-To: <CAN7WH3JG6AhY2dUz1ZYZ9CHgMh1xxZ2kYTT5=uufehSPykE6qg@mail.gmail.com>
References: <CAN7WH3+HdpkMwXMJGuFCn6FHUZAqxtFo4Lx30SSGMZP7GZCq8g@mail.gmail.com>
	<20220130131111.zlabglymewik3zfc@jrouhaud>
	<CAN7WH3JG6AhY2dUz1ZYZ9CHgMh1xxZ2kYTT5=uufehSPykE6qg@mail.gmail.com>

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





view thread (14+ messages)  latest in thread

Message-ID: <20220130132353.uncxuf75vo5bthhj@jrouhaud>
Permalink:  ../20220130132353.uncxuf75vo5bthhj@jrouhaud/
Also on:    postgresql.org/message-id/20220130132353.uncxuf75vo5bthhj@jrouhaud

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: rjuju123@gmail.com, mr.yudianto@gmail.com
  Subject: Re: what is the solution like oracle DB's datafile
  In-Reply-To: <20220130132353.uncxuf75vo5bthhj@jrouhaud>
  References: <CAN7WH3+HdpkMwXMJGuFCn6FHUZAqxtFo4Lx30SSGMZP7GZCq8g@mail.gmail.com> <20220130131111.zlabglymewik3zfc@jrouhaud> <CAN7WH3JG6AhY2dUz1ZYZ9CHgMh1xxZ2kYTT5=uufehSPykE6qg@mail.gmail.com> <20220130132353.uncxuf75vo5bthhj@jrouhaud>

* 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