87c21bb941
This new DDL command splits a single partition into several parititions. Just like ALTER TABLE ... MERGE PARTITIONS ... command, new patitions are created using createPartitionTable() function with parent partition as the template. This commit comprises quite naive implementation which works in single process and holds the ACCESS EXCLUSIVE LOCK on the parent table during all the operations including the tuple routing. This is why this new DDL command can't be recommended for large partitioned tables under a high load. However, this implementation come in handy in certain cases even as is. Also, it could be used as a foundation for future implementations with lesser locking and possibly parallel. Discussion: https://postgr.es/m/c73a1746-0cd0-6bdd-6b23-3ae0b7c0c582%40postgrespro.ru Author: Dmitry Koval Reviewed-by: Matthias van de Meent, Laurenz Albe, Zhihong Yu, Justin Pryzby Reviewed-by: Alvaro Herrera, Robert Haas, Stephane Tachoires |
||
---|---|---|
.. | ||
expected | ||
sql | ||
.gitignore | ||
Makefile | ||
README | ||
meson.build | ||
test_ddl_deparse--1.0.sql | ||
test_ddl_deparse.c | ||
test_ddl_deparse.control |
README
test_ddl_deparse is an example of how to use the pg_ddl_command datatype. It is not intended to do anything useful on its own; rather, it is a demonstration of how to use the datatype, and to provide some unit tests for it. The functions in this extension are intended to be able to process some part of the struct and produce some readable output, preferably handling all possible cases so that SQL test code can be written.