Skip to main content
Question

How to calculate/set the batching factor (query) ?

  • September 21, 2020
  • 1 reply
  • 7 views
koumaran

Hi all,

The link below explains what the batching factor is. Does anyone know how to get/set this batching factor (query) ?
https://www.vertica.com/blog/write-optimized-storage-wos-deprecation-what-you-need-to-know/

What is Batching Factor?
Batching factor is a synthetic measure described as the number of commits divided by the number of files >written to disk. It is used to describe the effectiveness of the WOS.
We analyzed data loads across 4 million distinct tables across 500 customer accounts.

Thanks !
BR,
Koumaran

    1 reply

    koumaran
    • koumaran
    • Author
    • New Participant
    • October 14, 2020

    Hello Koumaran,
    Thank you Chaima and Abhishek for your help.
    select (sum(wcnt)/sum(mcnt))::int bfactor from (select time::varchar(13) stime, count(*) mcnt from dc_roses_created where plan_type in ('TM_DVWOS_MOVEOUT', 'TM_MOVEOUT') group by 1 ) a join (select time::varchar(13) stime , count(*) wcnt from dc_woses_committed group by 1) b on a.stime = b.stime;
    Have a nice day Koumaran !
    BR,
    Koumaran

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement