PostgreSQL 16

can anyone point to the COPY FROM improvements mentioned that can result in up to 300% performance improvements is it the line in the release notes about "ASCII string detection"?

Re: PostgreSQL 16

#7

Post by data_ders » Thu, Sep 14, 2023, 1:56 PM UTC

anytime a huge multi-decades-old FOSS project lands a milestone, I can't help but equate it to something like a moon landing.

So much (unpaid) work and thought goes into stewarding open software. Kudos to the whole team. Software infra is just as important as bridges and roads -- here's hoping we can fund it at least as well, for humanity's sake. [1]

[1]: https://www.fordfoundation.org/work/learning/research-report...

Re: PostgreSQL 16

#8

Post by JelteF » Thu, Sep 14, 2023, 1:58 PM UTC

data_ders wrote: post #6

can anyone point to the COPY FROM improvements mentioned that can result in up to 300% performance improvements is it the line in the release notes about "ASCII string detection"?

These are the two relevant patches that I know of (there might be more):

1. https://github.com/postgres/postgres/commit/3838fa269c15706d...

2. https://github.com/postgres/postgres/commit/121d2d3d70ecdb21...

It causes much less CPU overhead on the receiving side of a copy when receiving big JSON blobs.

Re: PostgreSQL 16

#9

Post by datadrivenangel » Thu, Sep 14, 2023, 2:03 PM UTC

> Add SQL/JSON constructors and identity functions

This will be a nice quality of life addition!

Re: PostgreSQL 16

#10

Post by ZiiS » Thu, Sep 14, 2023, 2:05 PM UTC

data_ders wrote: post #7

anytime a huge multi-decades-old FOSS project lands a milestone, I can't help but equate it to something like a moon landing. So much (unpaid) work and thought goes into stewarding open software. Kudos to the whole team. Software infra is just as important as bridges and roads -- here's hoping we can fund it at least as well, for humanity's sake. [1] [1]: https://www.fordfoundation.org/work/learning/research-report..…

[flagged]