From 72a0333c7898fdbcdb13317ad6c8a05810b45d87 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 13 Jan 2008 17:58:54 +0000 Subject: [PATCH] Add note pointing out that read-only commands no longer consume command IDs. --- doc/src/sgml/ddl.sgml | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 8ed0e48dfd..00aac8d3c9 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1034,12 +1034,14 @@ CREATE TABLE order_items ( - Command - identifiers are also 32-bit quantities. This creates a hard limit + Command identifiers are also 32-bit quantities. This creates a hard limit of 232 (4 billion) SQL commands within a single transaction. In practice this limit is not a problem — note that the limit is on number of SQL commands, not number of rows processed. + Also, as of PostgreSQL 8.3, only commands + that actually modify the database contents will consume a command + identifier. -- 2.39.5