| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pl/pgsql slowness |
| Date: | 2000-11-20 17:06:01 |
| Message-ID: | 3A1959F9.26B53770@tm.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
>
> Hannu Krosing <hannu(at)tm(dot)ee> writes:
> > Is it normal that a query that takes <1 sec when executed from psql
> > prompt takes > 15 sek when executed from a function
>
> No. I can't reproduce the quoted misbehavior under either 7.0.2 or
> current sources; your example takes ~1 sec either way for me.
Sorry, my fault.
I ran the queries over two similar tables, but the slow one had several
huge indexes on it.
They had grown huge over time and vacuum did nothing to reduce them.
So it seems that it had nithing to do with plpgsql.
-----------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 2000-11-20 17:15:53 | Re: Table/Column Constraints |
| Previous Message | Hannu Krosing | 2000-11-20 16:52:20 | Re: Table/Column Constraints |