We need to wait for the postgres upgrade, so a temporary solution had to
be made. All the foreign key constraints were dropped and added again
with INITIALLY DEFERRED flag. Everything seems to be working fine now.
If anyone is interested I can provide files with sql queries I used.
Pawel
Pawel
Thank you very much.
I thought about altering database schema somehow to set the constraints
'initially deferred' and check if that works (in small examples it
worked fine), but if a new version makes no trouble it doesn't make
sense any more. Thanks once again for your help.
Pawel Sztromwasser
Nicklas Nordborg wrote:
> 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
> s
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 postgreSQ
Paweł Sztromwasser wrote:
> When you run one job at a time it takes about 40-45 sec. Here are the
> times for 5 users trying to import simultanously
>
> no created started ended ended - started(sec)
> 1 11:59:16 11:59:22 12:00:02 40
> 2 11:59:16 11:59:30 12:00:40 70
> 3 11:59:16 11:59:4
When you run one job at a time it takes about 40-45 sec. Here are the
times for 5 users trying to import simultanously
no created started ended ended - started(sec)
1 11:59:16 11:59:22 12:00:02 40
2 11:59:16 11:59:30 12:00:40 70
3 11:59:16 11:59:45 12:01:17 92
4 11:59:16 11:59:42 12
Paweł Sztromwasser wrote:
> All job agents were configured to run all installed plugins and
> Everyone group has access to them. In fact each of them is able to run
> a job, but only if no other job is running. I saw couple of times (on
> JobAgents tab in web UI), as 4 of jobs were assigned to (le
2007/10/29, Nicklas Nordborg <[EMAIL PROTECTED]>:
> Paweł Sztromwasser wrote:
> > Hi,
> >
> > I am trying to test the performance of Base2 (2.4.3) installation on
> > our server. It is an 8-processor machine so we thought about running
> > several job agents on it to speed up the plugin execution.
Paweł Sztromwasser wrote:
> Hi,
>
> I am trying to test the performance of Base2 (2.4.3) installation on
> our server. It is an 8-processor machine so we thought about running
> several job agents on it to speed up the plugin execution.
You will not gain anything by running multiple job agents on
Hi,
I am trying to test the performance of Base2 (2.4.3) installation on
our server. It is an 8-processor machine so we thought about running
several job agents on it to speed up the plugin execution.
I started and configured 5 of them, following instructions from
documentation. All are using the
10 matches
Mail list logo