Skip to main content

FENCED option in CREATE TRANSFORM FUNCTION

  • February 4, 2016
  • 2 replies
  • 12 views
Suhrid_R__Ghosh
Forum|alt.badge.img+1

Hello,

 

        We are using some C++ UDF in vertica with FENCED option since it is safe. Can anybody tell what are the risks which we might face when using FENCED mode ?

 

Thanks,

Suhrid Ghosh

    2 replies

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • February 4, 2016

    Hi ,

    As I see it , mostly performances ( according to Vertica doc around 10% degradation ) ,  but I believe that its  very related to your use case   .

    You probably  should see more CPU context switching  as two process (instead  of one ) are processing the request

     

    Thanks

    Sharon_Cutter
    Forum|alt.badge.img
    • Sharon_Cutter
    • Participating Frequently
    • February 4, 2016

    I've seen fenced UDFs perform as much as 20x slower.  As Eli said, it depends on the use case.

     

      --Sharon

     

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement