Re: Tablespace size in TB - Mailing list pgsql-general

From masheed ullah
Subject Re: Tablespace size in TB
Date
Msg-id CAHr8x_sCFOpufrmTPBF2nOFMyJfWG6EPHMfN+UOiKdfLF_kVdA@mail.gmail.com
Whole thread
In response to Re: Tablespace size in TB  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Tablespace size in TB
Re: Tablespace size in TB
List pgsql-general
Just to check like Oracle, parallelism works well with multiple tablespaces.
Moving tables/ indexes to multiple tablespaces to use the parallelism to boost the backup speed. With a single tablespace, parallelism will not work.

On Sun, May 3, 2026 at 3:21 PM Laurenz Albe <laurenz.albe@cybertec.at> 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?

Yours,
Laurenz Albe



pgsql-general by date:

Previous
From: Jan Karremans
Date:
Subject: Re: Tablespace size in TB
Next
From: masheed ullah
Date:
Subject: Re: Tablespace size in TB