Re: Tablespace size in TB

From: Jan Karremans <karremans(dot)ja(at)gmail(dot)com>
To: masheed ullah <masheedullah(at)gmail(dot)com>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Tablespace size in TB
Date: 2026-05-03 12:47:56
Message-ID: 81DB47B9-3244-41BA-980D-66AC371C8CA6@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can safely recommend pgBackRest as several PostgreSQL companies have already stepped up to take over/fork pgBackRest.

> On 3 May 2026, at 14:30, masheed ullah <masheedullah(at)gmail(dot)com> wrote:
>
> 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(dot)ja(at)gmail(dot)com <mailto:karremans(dot)ja(at)gmail(dot)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(dot)albe(at)cybertec(dot)at <mailto:laurenz(dot)albe(at)cybertec(dot)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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Olivier Gautherot 2026-05-03 13:18:47 Re: Tablespace size in TB
Previous Message masheed ullah 2026-05-03 12:30:56 Re: Tablespace size in TB