public inbox for pgsql-general@postgresql.org  

help / color / mirror / Atom feed

From: Jan Karremans <karremans.ja@gmail.com>
To: masheed ullah <masheedullah@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Thiemo Kellner <thiemo@gelassene-pferde.biz>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Tablespace size in TB
Date: Sun, 3 May 2026 14:47:56 +0200
Message-ID: <81DB47B9-3244-41BA-980D-66AC371C8CA6@gmail.com> (raw)
In-Reply-To: <CAHr8x_u4FedXmcAznU8FdJ4vyxqGdPfKJdtrVwa5mAh4hzLDQg@mail.gmail.com>
References: <CAHr8x_tgJh2vb8gyq-kmrbtKstaAYUpmWC3+umwGXhOZYeMxOQ@mail.gmail.com>
	<CDB30DC3-C4C6-4437-93E8-6440E0B03782@gmail.com>
	<ba2496302b3d6ae301b90f442bd22dc63cd285af.camel@cybertec.at>
	<86590390-F0A6-448A-985A-AA7CCC5D9C16@gmail.com>
	<CAHr8x_u4FedXmcAznU8FdJ4vyxqGdPfKJdtrVwa5mAh4hzLDQg@mail.gmail.com>

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@gmail.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.ja@gmail.com <mailto: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 <mailto: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 
> 
> 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: karremans.ja@gmail.com, masheedullah@gmail.com, laurenz.albe@cybertec.at, thiemo@gelassene-pferde.biz, pgsql-general@lists.postgresql.org
  Subject: Re: Tablespace size in TB
  In-Reply-To: <81DB47B9-3244-41BA-980D-66AC371C8CA6@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox