On 9/21/21 12:09 AM, Justin Pryzby wrote:
> On Mon, Sep 20, 2021 at 10:19:32PM -0400, Jonathan S. Katz wrote:
>
>> PostgreSQL 14 provides a significant throughput boost on workloads that use many
>> connections, with some benchmarks showing a 2x speedup. This release continues
>> on the recent improvements the overall management of B-tree indexes by reducing
>> index bloat on tables with [frequently updated
indexes](https://www.postgresql.org/docs/14/btree-implementation.html#BTREE-DELETION).
>
> improvements *in* ?
Modified, albeit a bit differently.
>> [Foreign data wrappers](https://www.postgresql.org/docs/14/sql-createforeigndatawrapper.html),
>> used to work with federated workloads across PostgreSQL and other databases, can
>
> It'd be clearer to write "used for working".
> "Used to work" sounds like it no longer works.
Modified, albeit a bit differently.
>> PostgreSQL 14 extends its performance gains to its
[vacuuming](https://www.postgresql.org/docs/14/routine-vacuuming.html)
>
> to *the* vacuuming system ?
I think this could go either way, but I changed it to the above suggestion.
>> indexes and now allows autovacuum to analyze partitioned tables and propagate
>> information to its parents.
>
> This was reverted last month.
I did not see that in the copy of the release notes that I was working
off of; I have gone ahead and removed it from the press release. Thanks!
>
>> The choice of compression for PostgreSQL's [TOAST](https://www.postgresql.org/docs/14/storage-toast.html)
>> system, which is used to store larger data like blocks of text or geometries,
>> can [now be
configured](https://www.postgresql.org/docs/14/runtime-config-client.html#GUC-DEFAULT-TOAST-COMPRESSION).
>
> Remove "the choice of" ?
Modified.
>> The [extended systems](https://www.postgresql.org/docs/14/planner-stats.html#PLANNER-STATS-EXTENDED)
>
> s/systems/statistics/
>
>> includes many improvements in PostgreSQL 14, including the ability to apply
>> extend statistics on expressions. Additionally,
>
> s/extend/extended/
Modified, albeit a bit differently.
Updated draft attached. As a reminder, please provide any feedback on
the press release no later than **Thu, Sep 23, 2021 @ 18:00 UTC**.
Thanks!
Jonathan