Re: PostgreSQL 14 press release draft

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: PostgreSQL 14 press release draft
Дата
Msg-id CAKAnmm++kkFUPAfJK45hkbBKZx1FPggw-TXnN+UoT6hxCkT1ZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 14 press release draft  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Ответы Re: PostgreSQL 14 press release draft  ("Jonathan S. Katz" <jkatz@postgresql.org>)
Список 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? :)


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Euler Taveira"
Дата:
Сообщение: Re: logical replication restrictions
Следующее
От: Marcos Pegoraro
Дата:
Сообщение: Re: logical replication restrictions