I would also like to add this:

The explain analyze show that the index on that numeric field *is not* being 
used.
I also try to set the seqscan off but that index continues not to be used.

Maybe the problem is this?

Thank you again!
/F

Hi,

maybe I missed something, but it appears to me you did NOT yet show the 
complete actual query + plan.
All we saw is the explain analyze of the call to the procedure 
function_cloud_view_orari(), but we
don't know what's happening inside the procedure.

Bye,
Chris.








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

Reply via email to