| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Marcin Krawczyk <jankes(dot)mk(at)gmail(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: function call |
| Date: | 2014-08-11 19:01:20 |
| Message-ID: | 53E91300.1050005@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 | Pavel Stehule | 2014-08-11 19:34:57 | Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' |
| Previous Message | Igor Neyman | 2014-08-11 18:38:14 | Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' |