MIME-Version: 1.0
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>
In-Reply-To: <86590390-F0A6-448A-985A-AA7CCC5D9C16@gmail.com>
From: masheed ullah <masheedullah@gmail.com>
Date: Sun, 3 May 2026 15:30:56 +0300
Message-ID: <CAHr8x_u4FedXmcAznU8FdJ4vyxqGdPfKJdtrVwa5mAh4hzLDQg@mail.gmail.com>
Subject: Re: Tablespace size in TB
To: Jan Karremans <karremans.ja@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Thiemo Kellner <thiemo@gelassene-pferde.biz>, 
	pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000096b8d0650e8fdbf"
Archived-At: <https://www.postgresql.org/message-id/CAHr8x_u4FedXmcAznU8FdJ4vyxqGdPfKJdtrVwa5mAh4hzLDQg%40mail.gmail.com>
Precedence: bulk

--000000000000096b8d0650e8fdbf
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM Jan Karremans <karremans.ja@gmail.co=
m> 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 no=
t
> a logical abstraction.
> >> Moving tables from one table space to another becomes so much easier b=
y
> that.
> >
> > I am confused.  Yes, if you have more than a single (default) tablespac=
e,
> > 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
>
>

--=20
Best Regards,
*Masheed Ullah*

--000000000000096b8d0650e8fdbf
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">The issue is, 13tb database BARMAN backup is taking 20 hou=
rs and restore takes 24 hours.<br>So the main agenda is to reduce the=C2=A0=
backup time to less than 10hours.<div><br>=C2=A0So does any solution/ tool =
I recommend to client.</div><div><br></div><div>. I just checked pgBeckRest=
 has no more support, so I can not suggest it to client.</div></div><br><di=
v class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gma=
il_attr">On Sun, May 3, 2026 at 3:25=E2=80=AFPM Jan Karremans &lt;<a href=
=3D"mailto:karremans.ja@gmail.com">karremans.ja@gmail.com</a>&gt; wrote:<br=
></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex">My thinking would =
be to have the different directories on different tiers of storage.<br>
<br>
Cheers,<br>
Jan<br>
<br>
&gt; On 3 May 2026, at 14:21, Laurenz Albe &lt;<a href=3D"mailto:laurenz.al=
be@cybertec.at" target=3D"_blank">laurenz.albe@cybertec.at</a>&gt; wrote:<b=
r>
&gt; <br>
&gt; On Sun, 2026-05-03 at 14:10 +0200, Jan Karremans wrote:<br>
&gt;&gt; Contrary to Oracle, a table space in PostgreSQL is a directory. An=
d not a logical abstraction.<br>
&gt;&gt; Moving tables from one table space to another becomes so much easi=
er by that.<br>
&gt; <br>
&gt; I am confused.=C2=A0 Yes, if you have more than a single (default) tab=
lespace,<br>
&gt; moving tables between tablespaces becomes possible and hence easier.<b=
r>
&gt; But why would you want to move tables between tablespaces in the first=
 place?<br>
&gt; <br>
&gt; Yours,<br>
&gt; Laurenz Albe<br>
<br>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr"><div><font face=3D"sans-serif" size=3D"2">Best R=
egards,</font><font size=3D"3"> </font><font face=3D"sans-serif" size=3D"2"=
><br>
<b>Masheed <font size=3D"2">Ullah</font></b> <br>
</font><br></div><br></div></div>

--000000000000096b8d0650e8fdbf--