On Sun, 26 Jun 2005, Petr Jelínek wrote:

Alvaro Herrera wrote:

Maybe you could make some checks against the shared array of PGPROCs
(procarray.c), for the per-database limit at least.  Not sure about
per-user limit.

Thats good idea (I could maybe add userid to PGPROC struct too) but I think there could be problem with two phase commits because they add new entry to that array of PGPROCs too and I don't kow if we want to include them to that limit.

You can ignore PGPROCs that belong to prepared transactions. They have 0 in the pid field, see TransactionIdIsActive and CountActiveBackends functions in procarray.c for an example.

- Heikki

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to