The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

FENCED option in CREATE TRANSFORM FUNCTION

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

  • 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

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.