ne 30. 1. 2022 v 18:13 odesílatel Yudianto Prasetyo <mr.yudianto@xxxxxxxxx> 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@xxxxxxxxx> 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.
