From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
---|---|
To: | Yudianto Prasetyo <mr(dot)yudianto(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: what is the solution like oracle DB's datafile |
Date: | 2022-01-30 13:11:11 |
Message-ID: | 20220130131111.zlabglymewik3zfc@jrouhaud |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
On Sun, Jan 30, 2022 at 05:15:33AM +0700, Yudianto Prasetyo wrote:
>
> I'm confused when I have 2 HDD. HDD 1 is used to install the OS and
> postgresql database. when HDD 1 is full. how to increase the capacity of
> postgresql database with HDD 2 (without RAID system)?
>
> is there any other way like oracle DB's "add datafile" which can be used to
> add capacity to another HDD?
I don't know how those datafiles are working, but with postgres the solution is
to create additional tablespaces pointing to the new drives, see
https://www.postgresql.org/docs/current/sql-createtablespace.html.
Note that a single non-partitioned table can only exist on a single tablespace,
so if you have a gigantic table that's becoming bigger than you disk, the
solution might be to partition it and store different partitions on different
tablespaces.
From | Date | Subject | |
---|---|---|---|
Next Message | Julien Rouhaud | 2022-01-30 13:23:53 | Re: what is the solution like oracle DB's datafile |
Previous Message | Mladen Gogala | 2022-01-29 22:16:32 | Re: pg_try_advisory_lock is waiting? |