Different situations is with C or PL/pgSQL or other languages - these functions are black box for the optimizer and there flags are necessary.ReplyDeleteRepliesJustinApril 19, 2013 at 12:18 AMMarking as stable (which should be true for any SQL function I believe) helps in that you can EXPLAIN ANALYZE the function invocation and get a meaningful plan.DeleteReplyThomApril 18, 2013 at 12:06 AMIf you'