From: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
---|---|
To: | Andres Freund <andres(at)anarazel(dot)de> |
Cc: | Erik Rijkers <er(at)xs4all(dot)nl>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Nathan Bossart <nathandbossart(at)gmail(dot)com> |
Subject: | Re: PostgreSQL 16 Beta 1 release announcement draft |
Date: | 2023-05-25 01:20:30 |
Message-ID: | ecdb13f7-b546-4e58-9954-2af30f38a0c2@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 5/24/23 8:04 PM, Andres Freund wrote:
> Hi,
>
> On 2023-05-24 19:57:39 -0400, Jonathan S. Katz wrote:
>> On 5/24/23 5:28 PM, Andres Freund wrote:
>>>
>>> I think the relation extension improvements ought to be mentioned here as
>>> well? Up to 3x faster concurrent data load with COPY seems practically
>>> relevant.
>>
>> I missed that -- not sure I'm finding it in the release notes with a quick
>> grep -- which commit/thread is this?
>
> It was split over quite a few commits, the one improving COPY most
> significantly is
>
> commit 00d1e02be24987180115e371abaeb84738257ae2
> Author: Andres Freund <andres(at)anarazel(dot)de>
> Date: 2023-04-06 16:35:21 -0700
>
> hio: Use ExtendBufferedRelBy() to extend tables more efficiently
>
> Relevant thread: https://postgr.es/m/20221029025420.eplyow6k7tgu6he3@awork3.anarazel.de
>
> It's in the release notes as:
> Allow more efficient addition of heap and index pages (Andres Freund)
Ah, OK, that's why I didn't grok it. I read through the first message
in[1] and definitely agree it should be in the announcement. How about:
"PostgreSQL 16 also shows up to a 300% improvement when concurrently
loading data with `COPY`"
Thanks,
Jonathan
[1] https://postgr.es/m/20221029025420.eplyow6k7tgu6he3@awork3.anarazel.de
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2023-05-25 01:28:40 | Re: Proposal: Removing 32 bit support starting from PG17++ |
Previous Message | Tom Lane | 2023-05-25 01:04:12 | Re: Proposal: Removing 32 bit support starting from PG17++ |