On Sun, 2026-05-03 at 14:25 +0200, Jan Karremans wrote: > > > On 3 May 2026, at 14:21, Laurenz Albe <[email protected]> wrote: > > > > On Sun, 2026-05-03 at 14:10 +0200, Jan Karremans wrote: > > > Contrary to Oracle, a table space in PostgreSQL is a directory. And not a > > > logical abstraction. > > > Moving tables from one table space to another becomes so much easier by > > > that. > > > > I am confused. Yes, if you have more than a single (default) tablespace, > > moving tables between tablespaces becomes possible and hence easier. > > But why would you want to move tables between tablespaces in the first > > place? > > My thinking would be to have the different directories on different tiers of > storage.
I see. That can indeed improve the throughput, but you don't need tablespaces for that: it would be simpler to define a striped logical volume. Yours, Laurenz Albe
