はてなブックマーク

September 14, 2023 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 16, the latest version of the world's most advanced open source database. PostgreSQL 16 raises its performance, with notable improvements to query parallelism, bulk data loading, and logical replication. There are many features in this release for developers and administrators alike, including mo

October 13, 2022 - The PostgreSQL Global Development Group today announced the release of PostgreSQL 15, the latest version of the world’s most advanced open source database. PostgreSQL 15 builds on the performance improvements of recent releases with noticeable gains for managing workloads in both local and distributed deployments, including improved sorting. This release improves the developer e

The PostgreSQL Global Development Group today announced the release of PostgreSQL 14, the latest version of the world’s most advanced open source database. PostgreSQL 14 brings a variety of features that help developers and administrators deploy their data-backed applications. PostgreSQL continues to add innovations on complex data types, including more convenient access for JSON and support for n

Contents Original Press Release About PostgreSQL More About The Features Where to Download Documentation Licence Contacts Images and Logos Corporate Support Original Press Release PostgreSQL 13 Released! 2020年 9月 24日 —PostgreSQL Global Development Groupは本日、世界で最も高度なオープンソースデータベースの最新バージョンであるPostgreSQL13のリリースを発表しました。 PostgreSQL13では、インデックス作成およびルックアップシステムが大幅に改善されています。これにより、インデックスのスペース節約とパフォーマンス向上、集約またはパ

The PostgreSQL Global Development Group today announced the release of PostgreSQL 13, the latest version of the world’s most advanced open source database. PostgreSQL 13 includes significant improvements to its indexing and lookup system that benefit large databases, including space savings and performance gains for indexes, faster response times for queries that use aggregates or partitions, bett

PostgreSQL 12.2, 11.7, 10.12, 9.6.17, 9.5.21, and 9.4.26 Released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 12.2, 11.7, 10.12, 9.6.17, 9.5.21, and 9.4.26. This release fixes one security issue found in the PostgreSQL server and over 75 bugs reported over the last three months. Users should plan to update as soon as p

The PostgreSQL Global Development Group today announced the release of PostgreSQL 12, the latest version of the world's most advanced open source database. PostgreSQL 12 enhancements include notable improvements to query performance, particularly over larger data sets, and overall space utilization. This release provides application developers with new capabilities such as SQL/JSON path expression

Contents Original Press Release About PostgreSQL More About The Features Where to Download Documentation Licence Contacts Images and Logos Corporate Support Original Press Release PostgreSQL 12がリリースされました！ PostgreSQLグローバル開発グループは本日、世界で最も先進的なオープンソースデータベースの最新バージョンであるPostgreSQL 12のリリースを発表しました。 PostgreSQL 12の機能強化には、特に大規模なデータセットでのクエリパフォーマンスと、全体的なスペース使用率の大幅な改善が含まれます。 このリリースは、アプリケーション開発者に、SQL/JSONパス式のサポート、

PostgreSQL 11.5, 10.10, 9.6.15, 9.5.19, 9.4.24, and 12 Beta 3 Released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.5, 10.10, 9.6.15, 9.5.19, and 9.4.24, as well as the third beta of PostgreSQL 12. This release fixes two security issues in the PostgreSQL server, two security issues found in one of the PostgreSQL Wind

We are happy to announce a new release of the Postgres Operator. Notable changes among others are: New browser-based UI to manage Postgres clusters Operator can create cron jobs for logical backups Initialize standby cluster from WAL archive in S3 bucket Provide manifests for user-facing clusterroles New end-2-end test suite using kind New deployment options: Helm chart, Kustomization and OLM Than

On Mon, 1 Apr 2019 12:11:22 +0900 Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp> wrote: > On Thu, 27 Dec 2018 21:57:26 +0900 > Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp> wrote: > > > Hi, > > > > I would like to implement Incremental View Maintenance (IVM) on PostgreSQL. > > I am now working on an initial patch for implementing IVM on PostgreSQL. > This enables materialized views to be updated incr

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 PARTITION without blocking queries Automatic (but overridable) inlining of common table expressions (CTE

A query comes to the backend via data packets arriving through TCP/IP or Unix Domain sockets. It is loaded into a string, and passed to the parser, where the lexical scanner, scan.l, breaks the query up into tokens(words). The parser uses gram.y and the tokens to identify the query type, and load the proper query-specific structure, like CreateStmt or SelectStmt. The statement is then identified a

PostgreSQL 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25 Released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25. This release fixes one security issue as well as bugs reported over the last three months. All users using the affected versions of PostgreSQL should update as s

The PostgreSQL Global Development Group today announced the release of PostgreSQL 11, the latest version of the world’s most advanced open source database. PostgreSQL 11 provides users with improvements to overall performance of the database system, with specific enhancements associated with very large databases and high computational workloads. Further, PostgreSQL 11 makes significant improvement

The PostgreSQL Global Development Group announces that the first beta release of PostgreSQL 11 is now available for download. This release contains previews of all features that will be available in the final release of PostgreSQL 11, though some details of the release could change before then. In the spirit of the open source PostgreSQL community, we strongly encourage you to test the new feature

PostgreSQL 10.4, 9.6.9, 9.5.13, 9.4.18, and 9.3.23 released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.4, 9.6.9, 9.5.13, 9.4.18, 9.3.23. This release fixes one security issue as well as several bugs reported over the last three months. Users should plan to update at the next convenient downtime. Please see the "Upd

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.0. This release of pgAdmin 4 includes over 100 bug fixes and new features. For more details please see the release notes. pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see the website. Notable changes in this release include: The desktop runtime now runs as a system

PostgreSQL 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22 released! 2018-03-01 Security Update Release The PostgreSQL Global Development Group has released an update to all supported versions of the PostgreSQL database system, including 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22. The purpose of this release is to address CVE-2018-1058, which describes how a user can create like-named objects in different sc

PostgreSQL 10.2, 9.6.7, 9.5.11, 9.4.16, and 9.3.21 released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.2, 9.6.7, 9.5.11, 9.4.16, 9.3.21. This release fixes two security issues. This release also fixes issues with VACUUM, GIN indexes, and hash indexes that could lead to data corruption, as well as fixes for using pa

The PostgreSQL JDBC team is pleased to announce the release of version 42.2.1. This is primarily to fix some regressions: Most notably: Avoid connection failure when DateStyle is set to ISO (~PgBouncer) Package scram:client classes, so SCRAM works when using a shaded jar reWriteBatchedInserts=true causes syntax error with ON CONFLICT Issue Avoid failure in getPGArrayType when stringType=unspecifie

The JDBC group is proud to release version 42.2.0 Notable changes include: Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+) using the Ongres SCRAM library. PR 842 Make SELECT INTO and CREATE TABLE AS return row counts to the client in their command tags. Issue 958 PR 962 Support Subject Alternative Names for SSL connections. PR 952 Support isAutoIncrement metadata for Post

Hello, This is my first time posting on the list. Also, I was trying to find something on the list's history on this topic but without results. My idea is new statement with roughly the following format (similar to update): EXPIRE FROM my_table AT my_timestamp WHERE my_condition or EXPIRE FROM my_table AFTER my_interval WHERE my_condition The rows that match the `my_condition` will be deleted when

PostgreSQL 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24 released! The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 10.1, 9.6.6, 9.5.10, 9.4.15, 9.3.20, and 9.2.24. This release fixes three security issues. This release also fixes issues found in BRIN indexing, logical replication and other bugs reported over the past thre

Increase distance between flush requests during bulk file copies. copy_file() reads and writes data 64KB at a time (with default BLCKSZ), and historically has issued a pg_flush_data request after each write. This turns out to interact really badly with macOS's new APFS file system: a large file copy takes over 100X longer than it ought to on APFS, as reported by Brent Dearth. While that's arguably

A dump/restore using pg_dumpall or use of pg_upgrade or logical replication is required for those wishing to migrate data from any previous release. See Section 18.6 for general information on migrating to new major releases. Version 10 contains a number of changes that may affect compatibility with previous releases. Observe the following incompatibilities: Hash indexes must be rebuilt after pg_u