[PERFORM] function execute on v.9.2 slow down

Hi! I can't explain why function is slow down on same data. Postgresql.conf the same, hardware is more powerful. Diffrents is postgresql version Here it;s my tests Server 1 PSQL 9.1 FIRST RUN EXPLAIN (ANALYZE, BUFFERS) SELECT webclient.prc_ti_cache_alloc_dbl_update( 21325134 ); 'Result (

[PERFORM] Function execute slow down in 9.2

Hi! I can't explain why function is slow down on same data. Postgresql.conf the same, hardware is more powerful. Diffrents is postgresql version Here it;s my tests Server 1 PSQL 9.1 FIRST RUN EXPLAIN (ANALYZE, BUFFERS) SELECT webclient.prc_ti_cache_alloc_dbl_update( 21325134 ); 'Result (

Re: [PERFORM] Function execute slow down in 9.2

Hello it looks like known issue of sometimes dysfunctional plan cache in plpgsql in 9.2. similar issue http://postgresql.1045698.n5.nabble.com/Performance-problem-in-PLPgSQL-td5764796.html Regards Pavel Stehule 2013/8/12 Александр Белинский : > Hi! > I can't explain why function is slow down