Re: Slow cursor

Gregg Jaskiewicz wrote:
> Do you really need to query the catalogues ? That on its own is not a
> good idea if you want something to run fast and frequently.

I know, but I've used it just to show the problem with cursors. I have the same problem
with other slow queries, which execute within x seconds in psql or pgAdmin, but for loops
in functions it takes at least x seconds to fetch each row. So please just imagine, that
it's an other slow query.

--
____________________________________________________________________
Cezariusz Marek                   mob: +48 608 646 494
http://www.comarch.com/   tel: +48 33 815 0734
____________________________________________________________________