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]
