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

From masheed ullah
Subject Re: Tablespace size in TB
Date
Msg-id CAHr8x_u4FedXmcAznU8FdJ4vyxqGdPfKJdtrVwa5mAh4hzLDQg@mail.gmail.com
Whole thread
In response to Re: Tablespace size in TB  (Jan Karremans <karremans.ja@gmail.com>)
Responses Re: Tablespace size in TB
List pgsql-general
The issue is, 13tb database BARMAN backup is taking 20 hours and restore takes 24 hours.
So the main agenda is to reduce the backup time to less than 10hours.

 So does any solution/ tool I recommend to client.

. I just checked pgBeckRest has no more support, so I can not suggest it to client.

On Sun, May 3, 2026 at 3:25 PM Jan Karremans <karremans.ja@gmail.com> wrote:
My thinking would be to have the different directories on different tiers of storage.

Cheers,
Jan

> On 3 May 2026, at 14:21, 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



--
Best Regards,
Masheed Ullah


pgsql-general by date:

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