Versie 12 van PostgreSQL is uitgekomen. Dit populaire 'opensource relational database management system' draait op een groot aantal besturingssystemen en is daardoor uitstekend inzetbaar in diverse omgevingen. Het is een afgeleide van Ingres, nadat de hoofdontwikkelaar daarvan voor zichzelf is begonnen en deze database van opensource closedsource werd. Uitgebreide informatie over de veranderingen in versie 12 kan het deze pagina worden gevonden. De complete changelog staat hier, dit zijn in het kort de belangrijkste verbeteringen:
Major enhancements in PostgreSQL 12 include:
- General performance improvements, including:
- Optimizations to space utilization and read/write performance for B-tree indexes
- Partitioning performance enhancements, including improved query performance on tables with thousands of partitions, improved insertion performance with INSERT and COPY, and the ability to execute
ALTER TABLE ATTACH PARTITIONwithout blocking queries- Automatic (but overridable) inlining of common table expressions (CTEs)
- Reduction of WAL overhead for creation of GiST, GIN, and SP-GiST indexes
- Support for covering GiST indexes, via the
INCLUDEclause- Multi-column most-common-value (MCV) statistics can be defined via CREATE STATISTICS, to support better plans for queries that test several non-uniformly-distributed columns
- Enhancements to administrative functionality, including:
REINDEX CONCURRENTLYcan rebuild an index without blocking writes to its table- pg_checksums can enable/disable page checksums (used for detecting data corruption) in an offline cluster
- Progress reporting statistics for CREATE INDEX, REINDEX, CLUSTER, VACUUM FULL, and pg_checksums
- Support for the SQL/JSON path language
- Stored generated columns
- Nondeterministic ICU collations, enabling case-insensitive and accent-insensitive grouping and ordering
- New authentication features, including:
- Encryption of TCP/IP connections when using GSSAPI authentication
- Discovery of LDAP servers using DNS SRV records
- Multi-factor authentication, using the
clientcert=verify-fulloption combined with an additional authentication method inpg_hba.conf
:fill(white):strip_exif()/i/1395573402.jpeg?f=thumbmedium)
/u/175440/crop5b5f0d899a5e8_cropped.png?f=community){kind=small}
:strip_exif()/u/79762/got.gif?f=community){kind=small}
Master en/of bachelor.:strip_icc():strip_exif()/u/261244/avatar4-64x64.jpg?f=community){kind=avatar}
:strip_exif()/u/1658/elmuerte-avatar60.gif?f=community){kind=avatar}
:strip_icc():strip_exif()/u/17098/avatar_small.jpg?f=community){kind=avatar}
/u/47120/crop5b474591c4ffc.png?f=community){kind=small}
/u/70125/headshot%2520small.png?f=community){kind=small}
:strip_icc():strip_exif()/u/269508/crop55c9d5fae106a_cropped.jpeg?f=community){kind=small}
:strip_exif()/u/47900/baph.gif?f=community){kind=small}