Hi, I just found very interesting situation, statistic ( n_distinct in particular) records for one of my columns, greatly under calculated it saying:
49726, but in reality 33409816. So planer never choose index but rather using table scan, and query never returns, is it any way how I can improve that? I can turn seqscan off but is it safe? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org