# pgq Published articles for pgq. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## Waiting for PostgreSQL 19 - SQL Property Graph Queries (SQL/PGQ) DevFeed: [Waiting for PostgreSQL 19 - SQL Property Graph Queries (SQL/PGQ)]() Original publisher: [Read original article]() Author: depesz Published: 2026-07-31T16:57:44Z Content type: opinion Language: en Sources: [select \* from depesz;]() Topics: [PostgreSQL](), [SQL](), [Graphs](), [function](), [pattern matching]() Tags: [function](), [graph](), [graphs](), [pattern-matching](), [pg19](), [pgq](), [postgresql](), [property](), [sql](), [uncategorized](), [waiting]() ### AI overview The article discusses PostgreSQL's SQL/PGQ implementation for property graph queries, including GRAPH_TABLE, graph pattern matching, and related DDL commands. It notes that the change was later rolled back and expresses the author's uncertainty about the practical benefits and usability of the syntax. ### Source excerpt Important update This change has been rolled back. Discussion can be found here. On 16th of March 2026, Peter Eisentraut committed patch: SQL Property Graph Queries (SQL/PGQ) Implementation of SQL property graph queries, according to SQL/PGQ standard (ISO/IEC 9075-16:2023). This adds: - GRAPH_TABLE table function for graph pattern matching - DDL commands ... Continue reading "Waiting for PostgreSQL 19 - SQL Property Graph Queries (SQL/PGQ)" ## SFPUG meeting presentation on Skytools 3 replication tools DevFeed: [SFPUG meeting presentation on Skytools 3 replication tools]() Original publisher: [Read original article]() Published: 2013-07-17T22:00:00Z Content type: news Language: en Sources: [Dimitri Fontaine]() Topics: [Replication](), [version](), [PostgreSQL]() Tags: [pgq](), [postgresql](), [presentation](), [replication](), [version]() ### AI overview The San Francisco PostgreSQL User Group meeting featured a presentation of Skytools version 3, Skype's replication toolset, including Londiste and PGQ. ### Source excerpt A presentation of Skytools version 3, the replication toolset from Skype that includes Londiste and PGQ. ## Archiving data as fast as possible DevFeed: [Archiving data as fast as possible]() Original publisher: [Read original article]() Author: Dimitri Fontaine PostgreSQL Major Contributor; Author Published: 2013-07-05T13:30:00Z Content type: tutorial Language: en Sources: [Dimitri Fontaine]() Topics: [PostgreSQL](), [Database](), [Replication](), [Common Lisp]() Tags: [database](), [lisp](), [pgq](), [postgresql](), [replication](), [standby]() ### AI overview The article describes archiving data from one PostgreSQL table to another using writable common table expressions and a single transaction. It also discusses handling foreign keys, remote archiving, and throttling the process by monitoring replication lag on a Hot Standby server. ### Source excerpt In a recent article here we've been talking about how do do Batch Updates in a very efficient way, using the Writable CTE features available in PostgreSQL 9.1. I sometime read how Common Table Expressions changed the life of fellow DBAs and developers, and would say that Writable CTE are at least the same boost again. ## PostgreSQL Conference Europe 2012 DevFeed: [PostgreSQL Conference Europe 2012]() Original publisher: [Read original article]() Published: 2012-10-22T22:00:00Z Content type: article Language: en Sources: [Dimitri Fontaine]() Topics: [PostgreSQL](), [migration](), [MySQL](), [Amazon Web Services](), [Website]() Tags: [aws](), [conference](), [europe](), [migration](), [mysql](), [pgq](), [postgresql](), [presentation](), [queue](), [technologies](), [users](), [web]() ### AI overview An overview of PostgreSQL Conference Europe 2012, including talks on migrating the Fotolog website from MySQL to PostgreSQL on AWS and on PGQ Cooperative Consumers for sharing load across consumers on a transactional queue. The conference took place in Prague from October 23-26, 2012. ### Source excerpt The first talk is about a PostgreSQL Migration (from MySQL) of the Fotolog web site with 32 millions of users, 1 billion photos and 10 billion comments on those photos. The target architecture has been deployed to AWS. The second presentation is a Ligthning Talk about PGQ Cooperative Consumers, that allow sharing the load in between multiple consumers on the same transactional queue. ## PGQ Coop Consumers DevFeed: [PGQ Coop Consumers]() Original publisher: [Read original article]() Author: Dimitri Fontaine PostgreSQL Major Contributor; Author Published: 2012-03-12T13:43:00Z Content type: article Language: en Sources: [Dimitri Fontaine]() Topics: [PostgreSQL](), [Concurrent Programming](), [Job]() Tags: [batch](), [distributed](), [pgq](), [postgresql](), [queue](), [queues](), [replication](), [scale](), [worker](), [workers]() ### AI overview The article describes using PostgreSQL Queue (PGQ) for transactional batch processing in a high-scale architecture. It explains consolidating events from 1,280 source queues into five destination queues and using cooperative consumers to distribute processing across workers. ### Source excerpt While working a new PostgreSQL architecture for an high scale project that used to be in the top 10 of internet popular web sites (in terms of visitors), I needed to be able to off load some processing from the main path: that's called a batch job. This needs to be transactional: don't run the job if we did rollback; the transaction, process all events that were part of the same transaction in the same transaction, etc.