R: Postgres 9.6.1 big slowdown by upgrading 8.4.22

From: Job <Job(at)colliniconsulting(dot)it>
To: Job <Job(at)colliniconsulting(dot)it>, 'Tomas Vondra' <tomas(dot)vondra(at)2ndquadrant(dot)com>, Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Date: 2017-01-08 13:05:35
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EACC252@W2008DC01.ColliniConsulting.lan
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Mair 2017-01-08 15:25:12 Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Previous Message sin 2017-01-08 11:51:23 some amazing stuff