Re: postgres large database backup

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
Cc: Michael Loftis <mloftis(at)wgops(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: postgres large database backup
Date: 2022-12-01 14:40:21
Message-ID: CAM+6J94dnY-fG-JbvJmM08iwXNeQ1ukkFi0W+UgXQsR_T4wg1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I do not recall zfs snapshots took anything resource intensive, and it
> was quick.ill ask around for actual time.
>

Ok just a small note, out ingestion pattern is write anywhere, read
globally. So we did stop ingestion while snapshot was taken as we could
afford it that way. Maybe the story is different when snapshot is taken on
live systems which generate a lot of delta.

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn Tonies (Upscene Productions) 2022-12-01 14:58:37 Stored procedure code no longer stored in v14 and v15, changed behaviour
Previous Message Tom Lane 2022-12-01 14:29:39 Re: Finding free time period on non-continous tstzrange field values