pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI
Date: Thu, 16 Mar 2023 20:51:04 +0000
Message-ID: <E1pcuYy-003s5z-38@gemulon.postgresql.org> (raw)

Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITION OF.

Clarify that ATTACH/DETACH PARTITION can be used to perform partition
maintenance with less locking than straight CREATE TABLE/DROP TABLE.
This was already stated in some places, but not emphasized.

Back-patch to v14 where DETACH PARTITION CONCURRENTLY was added.
(We had lower lock levels for ATTACH PARTITION before that, but
this wording wouldn't apply.)

Justin Pryzby, reviewed by Robert Treat and Jakub Wartak;
a little further wordsmithing by me

Discussion: https://postgr.es/m/20220718143304.GC18011@telsasoft.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f170b572d2b4cc232c5b6d391b4ecf3e368594b7

Modified Files
--------------
doc/src/sgml/ddl.sgml              | 13 +++++++------
doc/src/sgml/ref/create_table.sgml | 20 ++++++++++++++++----
2 files changed, 23 insertions(+), 10 deletions(-)



view thread (3+ messages)  latest in thread

Message-ID: <E1pcuYy-003s5z-38@gemulon.postgresql.org>
Permalink:  ../E1pcuYy-003s5z-38@gemulon.postgresql.org/
Also on:    postgresql.org/message-id/E1pcuYy-003s5z-38@gemulon.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI
  In-Reply-To: <E1pcuYy-003s5z-38@gemulon.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox