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
____________________________________________________________________


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to