From: | "Bossart, Nathan" <bossartn(at)amazon(dot)com> |
---|---|
To: | David Steele <david(at)pgmasters(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Dipesh Pandit <dipesh(dot)pandit(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Jeevan Ladhe <jeevan(dot)ladhe(at)enterprisedb(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Andres Freund <andres(at)anarazel(dot)de>, Hannu Krosing <hannuk(at)google(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: .ready and .done files considered harmful |
Date: | 2021-09-27 18:03:33 |
Message-ID: | 1C66C803-2BE0-4B6C-B9EB-D53E65DD7392@amazon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 9/24/21, 9:29 AM, "Robert Haas" <robertmhaas(at)gmail(dot)com> wrote:
> So what I am inclined to do is commit
> v1-0001-Improve-performance-of-pgarch_readyXlog-with-many.patch.
> However, v6-0001-Do-fewer-directory-scans-of-archive_status.patch has
> perhaps evolved a bit more than the other one, so I thought I should
> first ask whether any of those changes have influenced your thinking
> about the batching approach and whether you want to make any updates
> to that patch first. I don't really see that this is needed, but I
> might be missing something.
Besides sprucing up the comments a bit, I don't think there is
anything that needs to be changed. The only other thing I considered
was getting rid of the arch_files array. Instead, I would swap the
comparator function the heap uses with a reverse one, rebuild the
heap, and then have pgarch_readyXlog() return files via
binaryheap_remove_first(). However, this seemed like a bit more
complexity than necessary.
Attached is a new version of the patch with some expanded comments.
Nathan
Attachment | Content-Type | Size |
---|---|---|
v3-0001-Improve-performance-of-pgarch_readyXlog-with-many.patch | application/octet-stream | 11.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Euler Taveira | 2021-09-27 18:09:49 | Re: two_phase commit parameter used in subscription for a publication which is on < 15. |
Previous Message | Christophe Pettus | 2021-09-27 17:42:09 | statement_timeout vs DECLARE CURSOR |