FENCED option in CREATE TRANSFORM FUNCTION

Suhrid_R__GhoshSuhrid_R__Ghosh ✭
in General Discussion

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

Comments

  • eli_revacheli_revach

    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_CutterSharon_Cutter ✭✭

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

     

      --Sharon

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...