We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


FENCED option in CREATE TRANSFORM FUNCTION — Vertica Forum

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