]> 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)
commit8f90381a20b259decfbb7174034ca7c457a041d0
tree49b92254a570de47099b2f2851671d6ee7a3c4a1
parentbbf18fe199c5844a39c8cb1aa60e5a13da8103c8
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