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.
