the planner will have no use for statistics on such columns.
Here is some help on how to see statistics per column:
http://stackoverflow.com/questions/15034622/check-statistics-targets-in-postgresql
Check if this is the case.
El 2 dic 2016, a las 1:26, Bill Measday <mailto:b...@measday.
ple I
gave uses the index, but I will take it up with them too.
Rgds
Bill
On 2/12/2016 10:48 AM, Tom Lane wrote:
Bill Measday writes:
Substantial different index use between 9.5 and 9.6
Maybe you missed an ANALYZE after migrating? The plan difference
seems to be due to a vast difference in r
Substantial different index use between 9.5 and 9.6
Postgres versions 9.5 and 9.6 running on Windows Server 2012. Installed
using EnterpriseDB. Both instances are on the same server,
postgresql.conf for both are the same except max_locks_per_transaction =
200 in 9.6 (caused insertion errors oth
