Re: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22 - Mailing list pgsql-general

From Chris Mair
Subject Re: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22
Date
Msg-id c36ec1f7cd5e34c7e2bd09b91e444540@smtp.hushmail.com
Whole thread Raw
In response to R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22  (Job <Job@colliniconsulting.it>)
Responses R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22  (Job <Job@colliniconsulting.it>)
List pgsql-general
> 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.








pgsql-general by date:

Previous
From: Job
Date:
Subject: R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22
Next
From: Job
Date:
Subject: R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22