Vertica Tip: Setting the Table-Level Active Partition Count

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Vertica Tip: Setting the Table-Level Active Partition Count

Post by JimKnicely » Sat Sep 22, 2018 2:32 pm

The Tuple Mover assumes that all loads and updates to a partitioned table are targeted to one or more partitions that it identifies as active. In general, the partitions with the largest partition keys—typically, the most recently created partitions—are regarded as active. As the partition ages, it commonly transitions to a mostly read-only workload and requires much less activity.

The configuration parameter ActivePartitionCount determines how many partitions are active for partitioned tables in the database. By default, ActivePartitionCount is set to 1.

As of Vertica 9.1.1, you can override ActivePartitionCount by setting a Table-Level Active Partition Count!

See an example here:
https://forum.vertica.com/discussion/23 ... tion-count
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”