| From: | masheed ullah <masheedullah(at)gmail(dot)com> |
|---|---|
| To: | Jan Karremans <karremans(dot)ja(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:30:56 |
| Message-ID: | CAHr8x_u4FedXmcAznU8FdJ4vyxqGdPfKJdtrVwa5mAh4hzLDQg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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> 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*
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Karremans | 2026-05-03 12:47:56 | Re: Tablespace size in TB |
| Previous Message | masheed ullah | 2026-05-03 12:26:45 | Re: Tablespace size in TB |