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.