Message-ID: <a7535c8db71d667cf909ac6c77883c956354f048.camel@cybertec.at>
Subject: Re: Tablespace size in TB
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: masheed ullah <masheedullah@gmail.com>
Cc: Jan Karremans <karremans.ja@gmail.com>, Thiemo Kellner
	 <thiemo@gelassene-pferde.biz>, pgsql-general@lists.postgresql.org
Date: Sun, 03 May 2026 19:04:29 +0200
In-Reply-To: <CAHr8x_sCFOpufrmTPBF2nOFMyJfWG6EPHMfN+UOiKdfLF_kVdA@mail.gmail.com>
References: 
	<CAHr8x_tgJh2vb8gyq-kmrbtKstaAYUpmWC3+umwGXhOZYeMxOQ@mail.gmail.com>
	 <CDB30DC3-C4C6-4437-93E8-6440E0B03782@gmail.com>
	 <ba2496302b3d6ae301b90f442bd22dc63cd285af.camel@cybertec.at>
	 <CAHr8x_sCFOpufrmTPBF2nOFMyJfWG6EPHMfN+UOiKdfLF_kVdA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/a7535c8db71d667cf909ac6c77883c956354f048.camel%40cybertec.at>
Precedence: bulk

On Sun, 2026-05-03 at 15:26 +0300, masheed ullah wrote:
> Just to check like Oracle, parallelism=C2=A0works well with multiple tabl=
espaces.
> Moving tables/ indexes to multiple tablespaces to use the parallelism to =
boost
> the backup speed. With a single tablespace, parallelism will not work.

That may be the case with Oracle, but not with PostgreSQL.

pg_basebackup will not parallelize at all.

I found the following article about backup tools useful:
https://thebuild.com/blog/2026/04/30/after-pgbackrest/

You should consider alternatives to parallelism, since parallelism
will only help up to the limit where the disk is saturated.
One think you should seriously consider is incremental backup,
which would reduce the backup time considerably (but not the
restore time).

Yours,
Laurenz Albe