Vertica documentation is moving! Use our new documentation site at https://docs.rocketsoftware.com/bundle/vertica_12.0/page/index.html

depot-pinning-best-practice.md

To minimize contention over depot usage, consider the following guidelines:

  • Pin only those objects that are most active in DML operations and queries.

  • Minimize the size of pinned data by setting policies at the smallest effective level—for example, pin only the data of a table's active partition.