From: | Yudianto Prasetyo <mr(dot)yudianto(at)gmail(dot)com> |
---|---|
To: | Josef Šimánek <josef(dot)simanek(at)gmail(dot)com> |
Cc: | Julien Rouhaud <rjuju123(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: what is the solution like oracle DB's datafile |
Date: | 2022-01-30 22:13:32 |
Message-ID: | CAN7WH3LM5ziC8qpX91biSER2hfpPf7ekksnhaxiMn94+nbLLCg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hello,
thanks for all the solutions. I don't think there is a solution like Oracle
DB's datafile in postgresql. LVM is probably the best way if using Linux OS.
Thank You
Yours faithfully
yudianto
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
On Mon, Jan 31, 2022 at 12:19 AM Josef Šimánek <josef(dot)simanek(at)gmail(dot)com>
wrote:
> ne 30. 1. 2022 v 18:13 odesílatel Yudianto Prasetyo
> <mr(dot)yudianto(at)gmail(dot)com> napsal:
> >
> > 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.
>
> Per my understanding, there is no exactly the same feature in
> PostgreSQL itself. As mentioned before, it is most likely by design.
>
> > 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 | Laurenz Albe | 2022-01-31 05:10:27 | Re: what is the solution like oracle DB's datafile |
Previous Message | Josef Šimánek | 2022-01-30 17:19:42 | Re: what is the solution like oracle DB's datafile |