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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
