From: | Greg Sabino Mullane <htamfids(at)gmail(dot)com> |
---|---|
To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PostgreSQL 14 press release draft |
Date: | 2021-09-22 16:57:57 |
Message-ID: | CAKAnmm++kkFUPAfJK45hkbBKZx1FPggw-TXnN+UoT6hxCkT1ZA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Some super quick nitpicks; feel free to ignore/apply/laugh off.
...
administrators to deploy their data-backed applications. PostgreSQL
continues to
add innovations on complex data types, including more conveniences for
accessing
JSON and support for noncontiguous ranges of data. This latest release also
adds
to PostgreSQL's trend on improvements for high performance and distributed
data workloads, with advances in support for connection concurrency,
high-write
workloads, query parallelism and logical replication.
>> add innovations on complex data types -> add innovations to? "on" sounds
odd
>> comma after "query parallelism" please
now works. This aligns PostgreSQL with commonly recognized syntax for
retrieving information from JSON data. The subscripting framework added to
PostgreSQL 14 can be generally extended to other nested data structures,
and is
also applied to the `hstore` data type in this release.
>> with commonly recognized syntax -> with the commonly recognized syntax
>> hyperlink hstore?
[Range types](https://www.postgresql.org/docs/14/rangetypes.html), also
first
released in PostgreSQL 9.2, now have support for noncontiguous ranges
through
the introduction of the "[multirange](
https://www.postgresql.org/docs/14/rangetypes.html#RANGETYPES-BUILTIN)".
A multirange is an ordered list of ranges that are nonoverlapping, which
allows
for developers to write simpler queries for dealing with complex sequences
of
>> introduction of the multirange -> introduction of the multirange type
>> which allows for developers to write -> which lets developers write
on the recent improvements to the overall management of B-tree indexes by
>> to the overall management -> to the management
operations. As this is a client-side feature, you can use pipeline mode
with any
modern PostgreSQL database so long as you use the version 14 client.
>> more complicated than "version 14 client", more like - if the
application has explicit
>> support for it and was compiled via libpq against PG 14.
>> Just don't want to overpromise here
[Foreign data wrappers](
https://www.postgresql.org/docs/14/sql-createforeigndatawrapper.html)
which are used for working with federated workloads across PostgreSQL and
other
>> which are used for -> used for
In addition to supporting query parallelism, `postgres_fdw` can now also
bulk
insert data on foreign tables and import table partitions with the
[`IMPORT FOREIGN SCHEMA`](
https://www.postgresql.org/docs/14/sql-importforeignschema.html)
directive.
>> can now also bulk insert -> can now bulk insert
>> on foreign tables and import -> on foreign tables, and can import
PostgreSQL 14 extends its performance gains to the [vacuuming](
https://www.postgresql.org/docs/14/routine-vacuuming.html)
system, including optimizations for reducing overhead from B-Trees.
>> B-Tree or B-tree - pick one (latter used earlier in this doc)
lets you uniquely track a query through several PostgreSQL systems,
including
[`pg_stat_activity`](
https://www.postgresql.org/docs/14/monitoring-stats.html#MONITORING-PG-STAT-ACTIVITY-VIEW
),
[`EXPLAIN VERBOSE`](https://www.postgresql.org/docs/14/sql-explain.html),
and
through several logging functions.
>> "several PostgreSQL systems" sounds weird.
>> "several logging functions" - not sure what this means
parallel queries when using the `RETURN QUERY` directive, and enabling
>> directive -> command
now benefit from incremental sorts, a feature that was introduced in
[PostgreSQL 13](
https://www.postgresql.org/about/news/postgresql-13-released-2077/)
>> that was introduced in -> introduced in
function. This release also adds the SQL conforming
[`SEARCH`](
https://www.postgresql.org/docs/14/queries-with.html#QUERIES-WITH-SEARCH)
and [`CYCLE`](
https://www.postgresql.org/docs/14/queries-with.html#QUERIES-WITH-CYCLE)
directives to help with ordering and cycle detection for recursive
[common table expressions](
https://www.postgresql.org/docs/14/queries-with.html#QUERIES-WITH-RECURSIVE
).
>> directives -> clauses
PostgreSQL 14 makes it convenient to assign read-only and write-only
privileges
>> convenient -> easy
companies and organizations. Built on over 30 years of engineering,
starting at
>> companies -> companies,
>> we claims 25 years at the top, 30 here. That's 5 non-open-source years?
:)
From | Date | Subject | |
---|---|---|---|
Next Message | Marcos Pegoraro | 2021-09-22 17:22:20 | Re: logical replication restrictions |
Previous Message | Euler Taveira | 2021-09-22 16:57:29 | Re: logical replication restrictions |