PostgreSQL 17 RC1 Released
PostgreSQL 17 RC1 was released on September 5, 2024, with general availability set for September 26, 2024. Users must follow a major upgrade strategy to transition from earlier versions.
Read original article
PostgreSQL 17 RC1 has been released by the PostgreSQL Global Development Group on September 5, 2024. This release candidate is expected to be nearly identical to the final version of PostgreSQL 17, which is scheduled for general availability on September 26, 2024. Users looking to upgrade to PostgreSQL 17 RC1 from earlier versions will need to follow a major version upgrade strategy, such as using pg_upgrade or pg_dump/pg_restore. Notable changes since the previous Beta 3 version include several bug fixes, the reversion of the MERGE/SPLIT partition feature, and improvements in performance related to logical decoding of subtransactions. For a comprehensive list of changes and fixes, users are encouraged to refer to the open items page. The release schedule indicates that unless significant issues arise, PostgreSQL 17 will be released as planned.
- PostgreSQL 17 RC1 is now available for download.
- General availability of PostgreSQL 17 is set for September 26, 2024.
- Upgrading to RC1 requires a major version upgrade strategy.
- Key fixes include performance improvements and the reversion of certain features.
- Users can find detailed information on the upgrade process in the documentation.
Related
Psycopg 3.2 released – PostgreSQL driver for Python
Psycopg 3.2 release brings Numpy scalar and PostgreSQL parameter format support, async enhancements, and PgBouncer interaction. It emphasizes maintaining crucial Python-PostgreSQL communication, aiding businesses and infrastructures with reliable interaction.
Postgres stores data on disk – this one's a page turner
PostgreSQL stores data in a structured directory at /var/lib/postgresql/data, containing essential subdirectories and files for database operations, access control, statistics, and transaction management, aiding developers in data optimization.
Does PostgreSQL respond to the challenge of analytical queries?
PostgreSQL has advanced in handling analytical queries with foreign data wrappers and partitioning, improving efficiency through optimizer enhancements, while facing challenges in pruning and statistical data. Ongoing community discussions aim for further improvements.
Postgres.new: In-browser Postgres with an AI interface
postgres.new is an in-browser Postgres sandbox that integrates AI assistance for managing databases, supporting features like CSV imports, report generation, and semantic search, with future cost-effective deployments planned.
The new PostgreSQL 17 make dist
PostgreSQL 17 improves tarball creation by using `git archive`, enhancing reproducibility and traceability while addressing previous complexities and security concerns, though challenges in complete reproducibility remain.
1 commentsRelated
Psycopg 3.2 released – PostgreSQL driver for Python
Psycopg 3.2 release brings Numpy scalar and PostgreSQL parameter format support, async enhancements, and PgBouncer interaction. It emphasizes maintaining crucial Python-PostgreSQL communication, aiding businesses and infrastructures with reliable interaction.
Postgres stores data on disk – this one's a page turner
PostgreSQL stores data in a structured directory at /var/lib/postgresql/data, containing essential subdirectories and files for database operations, access control, statistics, and transaction management, aiding developers in data optimization.
Does PostgreSQL respond to the challenge of analytical queries?
PostgreSQL has advanced in handling analytical queries with foreign data wrappers and partitioning, improving efficiency through optimizer enhancements, while facing challenges in pruning and statistical data. Ongoing community discussions aim for further improvements.
Postgres.new: In-browser Postgres with an AI interface
postgres.new is an in-browser Postgres sandbox that integrates AI assistance for managing databases, supporting features like CSV imports, report generation, and semantic search, with future cost-effective deployments planned.
The new PostgreSQL 17 make dist
PostgreSQL 17 improves tarball creation by using `git archive`, enhancing reproducibility and traceability while addressing previous complexities and security concerns, though challenges in complete reproducibility remain.