9.6 Table Partitioning

Table of Contents Previous Next


9 Enhanced Compatibility Features : 9.6 Table Partitioning

A bulk load (or unload) can be implemented by adding or removing partitions, if you plan that requirement into the partitioning design. ALTER TABLE is far faster than a bulk operation. It also entirely avoids the VACUUM overhead caused by a bulk DELETE.

9 Enhanced Compatibility Features : 9.6 Table Partitioning

Table of Contents Previous Next