Re: [GENERAL] DTrace and PostgreSQL

2007-04-13 Thread [EMAIL PROTECTED]
On Apr 12, 8:13 pm, "Karen Hill" <[EMAIL PROTECTED]> wrote: > 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(

Re: [GENERAL] DTrace and PostgreSQL

2007-04-12 Thread Alvaro Herrera
Karen Hill wrote: > 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

[GENERAL] DTrace and PostgreSQL

2007-04-12 Thread Karen Hill
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 p