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 03:30:58 |
Message-ID: | bd1c91e2-ada0-e3a2-e4b8-1a3a4109c9d9@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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`"
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
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan S. Katz | 2023-05-25 03:32:02 | Re: PostgreSQL 16 Beta 1 release announcement draft |
Previous Message | Thomas Munro | 2023-05-25 02:38:15 | Re: Proposal: Removing 32 bit support starting from PG17++ |