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 aswell? 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 quickgrep -- 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 <and...@anarazel.de> Date: 2023-04-06 16:35:21 -0700 hio: Use ExtendBufferedRelBy() to extend tables more efficientlyRelevant thread: https://postgr.es/m/20221029025420.eplyow6k7tgu6...@awork3.anarazel.deIt'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
OpenPGP_signature
Description: OpenPGP digital signature