ndf@rocketmail.com wrote:
I've run into a problem with Zope with PostgreSQL. The query runs and runs and runs till all the memory on the server is used up and Zope falls over. Everything works fine on a small table but comes apart as the number of fields in a table increases. For example, the table that I'm trying to query has 18 fields. I'm running postgresql-6.4.2, the ZPygreSQLDA is straight off of the Zope site. I've tried Zope versions from 1.10 all the way up through 2.0.0b1. Has anyone else had this problem? This is a very serious issue for me. Any help would be greatly appreciated if I'm doing something wrong.
I'm using it all the time with no major problems. Do the same queries run fine from psql ? Could you give some examples ? Schemas, row counts, queries executed ? Also OS, postgres and ZPygreSQLDA versions. It is a known fact that you are able to write certain queries that exhaust virtual memory on PostgreSQL. I guess this is true for other DBs too. ------- Hannu