Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22

From: Chris Mair <chris(at)1006(dot)org>
To: Job <Job(at)colliniconsulting(dot)it>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Date: 2017-01-08 15:25:12
Message-ID: c36ec1f7cd5e34c7e2bd09b91e444540@smtp.hushmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Job 2017-01-08 15:30:46 R: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Previous Message Job 2017-01-08 13:05:35 R: Postgres 9.6.1 big slowdown by upgrading 8.4.22