digoal
2021-07-28
PostgreSQL , access method
Add support for SET ACCESS METHOD in ALTER TABLE
author Michael Paquier <michael@paquier.xyz>
Wed, 28 Jul 2021 01:10:44 +0000 (10:10 +0900)
committer Michael Paquier <michael@paquier.xyz>
Wed, 28 Jul 2021 01:10:44 +0000 (10:10 +0900)
commit b0483263dda0824cc49e3f8a022dab07e1cdf9a7
tree e9aa48baf7b4159eae107a8a3cfb613927f9a854 tree
parent 4b763ff642e1a3608cbcaff062f6c2f465bfc6bd commit | diff
Add support for SET ACCESS METHOD in ALTER TABLE
The logic used to support a change of access method for a table is
similar to changes for tablespace or relation persistence, requiring a
table rewrite with an exclusive lock of the relation changed. Table
rewrites done in ALTER TABLE already go through the table AM layer when
scanning tuples from the old relation and inserting them into the new
one, making this implementation straight-forward.
Note that partitioned tables are not supported as these have no access
methods defined.
Author: Justin Pryzby, Jeff Davis
Reviewed-by: Michael Paquier, Vignesh C
Discussion: https://postgr.es/m/20210228222530.GD20769@telsasoft.com
您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议，奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等，奖品丰富，快来许愿。开不开森.
