Re: [HACKERS] Early locking option to parallel backup - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [HACKERS] Early locking option to parallel backup
Date
Msg-id CAB7nPqSUEoUD+FDSD+_e=V9uwd6M_PcJxQrO1SFL9pRh0VBnkQ@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Early locking option to parallel backup  (Lucas <lucas75@gmail.com>)
List pgsql-hackers
On Sun, Nov 5, 2017 at 7:17 PM, Lucas <lucas75@gmail.com> wrote:
> The patch creates a "--lock-early" option which will make pg_dump to issue
> shared locks on all tables on the backup TOC on each parallel worker start.
> That way, the backup has a very small chance of failing. When it does,
> happen in the first few seconds of the backup job. My backup scripts (not
> included here) are aware of that and retries the backup in case of failure.

You should register your patch to the next opened commit fest, which
will begin in January, if you are looking for feedback and review:
https://commitfest.postgresql.org/16/
-- 
Michael


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Lucas
Date:
Subject: [HACKERS] Early locking option to parallel backup
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] [POC] Faster processing at Gather node