On Tue, Aug 30, 2022 at 03:58:48PM -0400, Jonathan S. Katz wrote:
> In this latest release, PostgreSQL improves on its in-memory and on-disk sorting
> algorithms, with benchmarks showing speedups of 25% - 400% based on sort types.
rather than "based on": "depending on the data types being sorted"
> Building on work from the previous PostgreSQL release for allowing async remote
> queries, the PostgreSQL foreign data wrapper, `postgres_fdw`, can now commit
> transactions in parallel.
asynchronous
> benefits for certain workloads. On certain operating systems, PostgreSQL 15
s/certain/some ?
> supports the ability to prefetch WAL file contents and speed up recovery times.
> PostgreSQL's built-in backup command, `pg_basebackup`, now supports server-side
> compression of backup files with a choice of gzip, LZ4, and zstd.
remove "server-side", since they're also supported on the client-side.
> PostgreSQL 15 lets user create views that query data using the permissions of
users
> the caller, not the view creator. This option, called `security_invoker`, adds
> an additional layer of protection to ensure view callers have the correct
> permissions for working with the underlying data.
ensure *that ?
> alter server-level configuration parameters. Additionally, users can now search
> for information about configuration using the `\dconfig` command from the `psql`
> command-line tool.
rather than "search for information about configuration", say "list
configuration information" ?
> PostgreSQL server-level statistics are now collected in shared memory,
> eliminating the statistics collector process and writing these stats to disk.
and *the need to periodically* write these stats to disk
--
Justin