Re: Slow PL/pgSQL 8.0.RC5 (7.4.6. 3times faster)

Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> writes:
> Looks like something introduced between RC1 and RC5:

You mean here

2004-12-19 15:20 tgl

* src/: pl/plpgsql/src/pl_exec.c,
test/regress/expected/plpgsql.out, test/regress/sql/plpgsql.sql:
plpgsql's exec_eval_simple_expr() now has to take responsibility
for advancing ActiveSnapshot when we are inside a volatile
function. Per example from Gaetano Mendola. Add a regression test
to catch similar problems in future.

and here

2004-12-21 13:33 tgl

* src/: pl/plpgsql/src/pl_exec.c,
test/regress/expected/plpgsql.out, test/regress/sql/plpgsql.sql:
exec_eval_simple_expr() needs to do CommandCounterIncrement() not
just GetTransactionSnapshot() to ensure ActiveSnapshot advances
properly. Sigh. Extend regression test so it reveals this error
too.

regards, tom lane