pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / 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