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