Christian Paul B. Cosinas wrote:
Hi mark

I have so many functions, more than 100 functions in the database :) And I
am dealing about 3 million of records in one database.
And about 100 databases :)


LOL - sorry, mis-understood your previous message to mean you had identified *one* query where 'fetch all' was causing the problem!

Having said that, to make much more progress, you probably want to identify those queries that are consuming your resource, pick one of two of the particularly bad ones and post 'em.

There are a number of ways to perform said identification, enabling stats collection might be worth a try.

regards

Mark


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to