search

Tencent / TBase

TBase is an enterprise-level distributed HTAP database. Through a single database cluster to provide users with highly consistent distributed database services and high-performance data warehouse services, a set of integrated enterprise-level solutions is formed.
Other
1.38k stars 262 forks source link

vacuum_delta configuration #84

Closed ypma closed 3 years ago

ypma commented 3 years ago

39 how configuratio vacuum_delta on datanodes

   thanks!
q2683252 commented 3 years ago
  1. Adjust vacuum_delta to the maxium time your sql runs in seconds.
  2. For vacuum, adjust vacuum_defer_freeze_min_age to be greater than the number of xids consumed during vacuum_delta on datanode. then adjust autovacuum_freeze_max_age to be at least as twice much as vacuum_defer_freeze_min_age.