From: | "Karen Hill" <karen_hill22(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | DTrace and PostgreSQL |
Date: | 2007-04-13 00:13:59 |
Message-ID: | 1176423239.406850.192210@d57g2000hsg.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2007-04-13 01:08:26 | Re: DTrace and PostgreSQL |
Previous Message | Terry Martin | 2007-04-12 22:14:01 | question |