Low performance of pl/pgsql function

Low performance of pl/pgsql function

References

Reference NO 1

http://stackoverflow.com/questions/13583700/low-performance-of-pl-pgsql-function

Reference NO 2

http://blog.guillaume.lelarge.info/index.php/post/2012/03/31/Profiling-PL/pgsql-functions

Reference NO 3

http://www.postgresql.org/message-id/4B3CE73F.4050807@postnewspapers.com.au

Reference NO 4

http://postgresql.1045698.n5.nabble.com/SQL-functions-vs-PL-PgSQL-functions-td3210091.html

Reference NO 5

http://grokbase.com/t/postgresql/pgsql-general/09czb5x7h3/query-very-slow-when-in-plpgsql-function

Reference NO 6

http://bytes.com/topic/postgresql/answers/400354-slow-queries-pl-pgsql-function

Reference NO 7

http://blog.endpoint.com/2008/12/why-is-my-function-slow.html

Reference NO 8

http://postgres.cz/wiki/PL/pgSQL_(en)