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

Mark Kirkwood <markir@coretech.co.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 responsibilityfor advancing ActiveSnapshot when we are inside a
volatilefunction. Per example from Gaetano Mendola.  Add a regression testto 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() notjust
GetTransactionSnapshot()to ensure ActiveSnapshot advancesproperly.  Sigh.  Extend regression test so it reveals this
errortoo.
        regards, tom lane