[Zope] Zope + Postgresql = poor performance

Hannu Krosing hannu@tm.ee
Fri, 16 Feb 2001 03:02:39 +0200


marc lindahl wrote:
> 
> Meaning all other zope connections (nonpostgres) are blocked too?

Currently I guess it blocks all connections in that thread.

It used to be much worse - blocking all other threads too

It actually depends on the _pgmodule.so - if it gives up thread 
locks while the query is running. It used not to do it, but newer ones 
have this around PQexec.

        /* gets result */
        Py_BEGIN_ALLOW_THREADS
        self->last_result = PQexec(self->pgcnx->cnx, query);
	Py_END_ALLOW_THREADS

And thus they let other threads to run. 

Felipe's problem may be old version of _pgmodule.c from pygresqlda  
0.3rjr2 (and not from postgres distribution)

--------
Hannu