On 5/24/23 9:20 PM, Jonathan S. Katz wrote:
> 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@anarazel.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`"
I currently have it as the below in the release announcement. If it you
send any suggested updates, I can try to put them in before release:
PostgreSQL 16 can also improve the performance of concurrent bulk
loading of data using
[`COPY`](https://www.postgresql.org/docs/16/sql-copy.html) up to a 300%.
Jonathan