pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI 3+ messages / 1 participants [nested] [flat]
* pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI @ 2023-03-16 20:51 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2023-03-16 20:51 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI @ 2023-03-16 20:51 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2023-03-16 20:51 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b0488cb5113746a2847964c5cb26e5dc0e302b55 Modified Files -------------- doc/src/sgml/ddl.sgml | 13 +++++++------ doc/src/sgml/ref/create_table.sgml | 20 ++++++++++++++++---- 2 files changed, 23 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI @ 2023-03-16 20:51 Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 3+ messages in thread From: Tom Lane @ 2023-03-16 20:51 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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 ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/8f90381a20b259decfbb7174034ca7c457a041d0 Modified Files -------------- doc/src/sgml/ddl.sgml | 13 +++++++------ doc/src/sgml/ref/create_table.sgml | 20 ++++++++++++++++---- 2 files changed, 23 insertions(+), 10 deletions(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-03-16 20:51 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-03-16 20:51 pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI Tom Lane <tgl@sss.pgh.pa.us> 2023-03-16 20:51 pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI Tom Lane <tgl@sss.pgh.pa.us> 2023-03-16 20:51 pgsql: Doc: mention CREATE+ATTACH PARTITION with CREATE TABLE...PARTITI Tom Lane <tgl@sss.pgh.pa.us>
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