On Sun, Mar 20, 2005 at 22:39:57 -0500, Keith Worthington <[EMAIL PROTECTED]> wrote: > Hi All, > > I have been reading about set returning functions. What I would like to > know is is there a performance advantage in using SRFs versus querying a > view. Assuming the underlying SQL is the same for the view vs the > function except for the WHERE clause which of these would you expect to > be faster? Or does the planner realize all this...
In general you are going to be better off with a view, since the planner knows what the view is doing and there may be some optimizations it can make. Functions are just black boxes to the planner. > > SELECT * FROM view_big_query WHERE column1 = 1234; > > SELECT * FROM func_bug_query(1234); > > -- > Kind Regards, > Keith > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
