Re: PostgreSQL 16 Beta 1 release announcement draft - Mailing list pgsql-hackers

From Jonathan S. Katz
Subject Re: PostgreSQL 16 Beta 1 release announcement draft
Date
Msg-id bd1c91e2-ada0-e3a2-e4b8-1a3a4109c9d9@postgresql.org
Whole thread Raw
In response to Re: PostgreSQL 16 Beta 1 release announcement draft  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Responses Re: PostgreSQL 16 Beta 1 release announcement draft
Re: PostgreSQL 16 Beta 1 release announcement draft
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Proposal: Removing 32 bit support starting from PG17++
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: PostgreSQL 16 Beta 1 release announcement draft