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
OpenPGP_signature
Description: OpenPGP digital signature