Re: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22

Поиск
Список
Период
Сортировка
От Chris Mair
Тема Re: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22
Дата
Msg-id c36ec1f7cd5e34c7e2bd09b91e444540@smtp.hushmail.com
обсуждение исходный текст
Ответ на R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22  (Job <Job@colliniconsulting.it>)
Ответы R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22  (Job <Job@colliniconsulting.it>)
Список 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 по дате отправления:

Предыдущее
От: Job
Дата:
Сообщение: R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22
Следующее
От: Job
Дата:
Сообщение: R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22