Postgres Goodies in Ruby on Rails 7.1

async queries: send long-running queries the background while the code runs along, great for pages with multiple long-running queries that can be run in parallelcomposite primary keys: native support for using two or more columns as a primary keycommon table expression (ctes): native integration for a subquery for use later in the statementunlogged tables: native support for disabling Postgres’ WAL logs on a table (mostly for test environments), so that you get better performance on your tests that use databasesvalue normalization: a native, universal syntax for normalization of values (like downcase of a email column) instead of using before_validation.