From: | Yudianto Prasetyo <mr(dot)yudianto(at)gmail(dot)com> |
---|---|
To: | Julien Rouhaud <rjuju123(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 14:24:44 |
Message-ID: | CAN7WH3KRy+Z_F_JMs8XC7CDui6M_397Q3R=sR89HFwj4GwKNtQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
dafafile this oracle like this example. can be added to another hdd.
ALTER TABLESPACE lmtbsb
ADD DATAFILE '/u02/oracle/data/lmtbsb02.dbf' SIZE 1M;
ALTER TABLESPACE lmtbsb
ADD DATAFILE '/u03/oracle/data/lmtbsb02.dbf' SIZE 1M;
ALTER TABLESPACE lmtbsb
ADD DATAFILE 'e:\data\lmtbsb02.dbf' SIZE 1M;
ALTER TABLESPACE lmtbsb
ADD DATAFILE 'f:\data2\lmtbsb02.dbf' SIZE 1M;
i understand about that LVM solution. it is true that using this method can
be done. I'm just asking for a solution at the database level.
thank you
Yours faithfully
yudianto
On Sun, Jan 30, 2022 at 9:17 PM Julien Rouhaud <rjuju123(at)gmail(dot)com> wrote:
> On Sun, Jan 30, 2022 at 08:51:02PM +0700, Yudianto Prasetyo wrote:
> >
> > thanks for other solutions in the operating system section. LVM, RAID is
> > indeed one solution to this problem.
> >
> > Maybe there is another solution in the postgresql database like the
> > datafile in oracle DB?
>
> As I said I don't know how datafiles in oracle are working. All you have
> on
> postgres is tablespaces, default tablespaces and moving relations from one
> tablespaces to another.
>
> In general, postgres doesn't try to reimplement solution to problems that
> are
> nicely solved at the operating system level, so if those datafile are
> reimplementing something similar to LVM, then no postgres doesn't have
> something like that and probably doesn't want it.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mladen Gogala | 2022-01-30 17:03:52 | Re: what is the solution like oracle DB's datafile |
Previous Message | Julien Rouhaud | 2022-01-30 14:17:06 | Re: what is the solution like oracle DB's datafile |