| From: | Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: function call |
| Date: | 2014-08-18 07:57:55 |
| Message-ID: | CABnqL33jQ_CzxkArfK1eH7ci1+qek6Q34YqiZX=FA3hA249=ew@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I wish I was doing that :) that's the first thing I checked.
pozdrowienia
mk
2014-08-11 21:01 GMT+02:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
> On 08/11/2014 02:50 AM, Marcin Krawczyk wrote:
>
>> I've managed to determine that there's a trigger dependency tree that
>> slows things down. When I DISABLE one of them the function takes under
>> 30 seconds, still more than from pgAdmin but much quicker than before.
>>
>
> I am with David. I am not sure you are calling the same function in each
> case.
>
> Are you sure you have not overloaded the function name and a difference in
> search_paths is not causing a different version to be run?
>
>
>
>> regards
>> mk
>>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | gmb | 2014-08-18 11:03:07 | Re: High memory usage / performance issue ( temp tables ? ) |
| Previous Message | Pavel Stehule | 2014-08-18 06:44:27 | Re: High memory usage / performance issue ( temp tables ? ) |