Slow index scan backward.

2018-03-05 Thread John van Breda
I have a single table with 45 columns and 6.5 million records with a roughly random distribution of data of a variety of types. I am trying to implement a data table with pagination in a web user interface, where the data table can be filtered in a very flexible way on pretty much any combination o

GIST index (polygon, point)

2018-03-05 Thread ghiureai
Hi List, I have a short description bellow from Dev team regarding the behaviour of gist index on the polygon column, looking to get some  feedback  from you: " I was expecting the <@(point,polygon) and @>(polygon,point) to be indexable but they are not. see bellow query output , the col