From: | KuroiNeko <evpopkov(at)carrier(dot)kiev(dot)ua> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Re: Requests for Development |
Date: | 2000-11-17 16:17:20 |
Message-ID: | 3A155A10.nail2CB11FQLK@ed.ed |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
> PL/pgSQL parses the entire function body at first call (per
> backend). But the SPI querystrings for all the statements
> aren't parsed at that time. It uses SPI_prepare() only for
> expressions and queries that actually get executed, so that a
> huge function that is called only once in a backend, erroring
> out at the first IF, will not parse most of it's queries.
> This is surely a win for performance, but it makes it
> difficult to develop.
Thanks for the explanation. Although, I can't see how this improves
performance, I'll keep this in my mind when designing PL/PGSQL SPs.
--
Sniper's rifle is an extension of his eye. He kills with his injurious vision.
JM
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2000-11-17 16:32:38 | Re: Strange problem upgrading to 7.0.3x |
Previous Message | Roberto Mello | 2000-11-17 16:06:17 | Re: Requests for Development |
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Rosenman | 2000-11-17 16:58:59 | Re: Requests for Development |
Previous Message | Roberto Mello | 2000-11-17 16:06:17 | Re: Requests for Development |