]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITION OF.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 16 Mar 2023 20:50:56 +0000 (16:50 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 16 Mar 2023 20:50:56 +0000 (16:50 -0400)
commitf170b572d2b4cc232c5b6d391b4ecf3e368594b7
tree3dd2cb3659703e9bb48e2eab7d03b0d176da8a49
parent5b3c5953553bb9fb0b171abc6041e7c7e9ca5b4d
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
doc/src/sgml/ddl.sgml
doc/src/sgml/ref/create_table.sgml