Pawel Sztromwasser wrote: > Nicklas Nordborg wrote: >> Pawel Sztromwasser wrote: >>> Hey, >>> >>> I came private to not spam others. Could you send me source code of >>> tests you used? I would like to check if this is not me doing >>> something wrong with the API before I get deep into postgreSQL things. >> >> I did it through the web interface so there is no special source code. >> >> /Nicklas >> > Ok. I am sure now that it is the database. > I wrote simple plugin that was only waiting for some seconds and run 5 > of them. Everything was fine.
I am taking this back to the mailing list in the hope that there is some Postgres expert that can shed some light on this. I found this http://www.thescripts.com/forum/thread174537.html It is about a rather old Postgres version (7.4). I am not sure if the same problem is still around. The problem is that when inserting data Postgres is locking all rows that are referenced by foreign keys. This means that if your five imports, for example, inserts data with references to the same reporter or feature on an array design, only one can proceed at a time. Actually, if this problem is still around in Postgres 8.2 I think this makes Postgres more or less unusable in a true multi-user setup. Since almost any data import or analysis plug-in will insert data and in many cases the new data will reference a reporter, an experiment or some other common item there is a high probability that only one job is able to proceed at a time. There is a tip about a "DEFERRED" mode that can overcome some limitations, but I am not very familiar with Postgres and don't really know how to set it. It would be good if there is a global server configuration option for this. Do you have the possibility to investigate this further? /Nicklas ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ basedb-devel mailing list basedb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/basedb-devel
