The feature, SQL Property Graph Queries (SQL/PGQ), became part of the SQL standard in 2023. It provides syntax for exploring relationships between nodes connected by edges. PostgreSQL's implementation ...

AlloyDB now features a next-gen architecture that lets you scale PostgreSQL alongside millions of concurrent AI queries without impacting production.

PostgreSQL window functions take center stage as this lesson breaks down lag, lead, and ntile with a clear, practical example. Using character names, species, and estimated net worth, the tutorial ...

PostgreSQL CASE statements make it possible to add conditional logic directly into SQL queries, working similarly to IF ELSE statements in programming languages and spreadsheet tools. This tutorial ...

Tiger Data, the creators of TimescaleDB, today announced that its open-source BM25 search engine, pg_textsearch, is now supported natively in Google Cloud’s AlloyDB and Cloud SQL for PostgreSQL ...

pg_later is an interesting project and extension built by Tembo which enables Postgres to execute queries asynchronously. Fire your query - but don't forget to check later for the result. Until now in ...

From reclaiming wasted storage to simplifying replication, PostgreSQL 19 gives database administrators more ways to manage large installations and keep applications running.

Next major release of the major open source relational database, now in beta, brings performance improvements to query execution and to logical replication. PostgreSQL 16, the next major update of the ...