Re: postgres large database backup - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: postgres large database backup
Date
Msg-id CAM+6J94dnY-fG-JbvJmM08iwXNeQ1ukkFi0W+UgXQsR_T4wg1Q@mail.gmail.com
Whole thread Raw
In response to Re: postgres large database backup  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Responses Re: postgres large database backup
List 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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Finding free time period on non-continous tstzrange field values
Next
From: "Martijn Tonies \(Upscene Productions\)"
Date:
Subject: Stored procedure code no longer stored in v14 and v15, changed behaviour