Don't uselessly rewrite, truncate, VACUUM, or ANALYZE partitioned tables.
Robert Haas <rhaas@postgresql.org>
Don't uselessly rewrite, truncate, VACUUM, or ANALYZE partitioned tables. Also, recursively perform VACUUM and ANALYZE on partitions when the command is applied to a partitioned table. In passing, some related documentation updates. Amit Langote, reviewed by Michael Paquier, Ashutosh Bapat, and by me. Discussion: http://postgr.es/m/47288cf1-f72c-dfc2-5ff0-4af962ae5c1b@lab.ntt.co.jp
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ddl.sgml | modified | +23 −24 |
| doc/src/sgml/ref/analyze.sgml | modified | +5 −2 |
| doc/src/sgml/ref/vacuum.sgml | modified | +3 −1 |
| src/backend/commands/analyze.c | modified | +25 −12 |
| src/backend/commands/tablecmds.c | modified | +12 −3 |
| src/backend/commands/vacuum.c | modified | +48 −3 |
Documentation touched
Discussion
- Partitioned tables and relfilenode 96 messages · 2017-02-10 → 2017-04-13