| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Lucas <lucas75(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Early locking option to parallel backup |
| Date: | 2017-11-05 12:17:12 |
| Message-ID: | CAB7nPqSUEoUD+FDSD+_e=V9uwd6M_PcJxQrO1SFL9pRh0VBnkQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sun, Nov 5, 2017 at 7:17 PM, Lucas <lucas75(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2017-11-05 14:22:31 | Re: [POC] Faster processing at Gather node |
| Previous Message | Lucas | 2017-11-05 10:17:47 | Early locking option to parallel backup |