I've got Solaris 10 11/06 on my PC. I removed the static keyword in
src/backend/access/transam/xact.c. for the AbortTransaction and
CommitTransaction functions declarations and compiled 8.2.3.
Everything works nicely.
I was wondering if DTrace could tell me how many inserts are being
done in a pl/pgsql function while in a loop for example. As you know
a pl/pgsql function executes in a single transaction so the DTrace
probe "transaction__commit(int)" I believe is not helpful here. Could
DTrace measure how many inserts are being done in a transaction that
has not yet been commited, especially if that transaction block is in
a pl/pgsql function? This would be extremely useful as when one has a
bunch of inserts one could be able to see how far along the pl/pgsql
function was.
regards,
karen
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
