[GENERAL] Perfomance of IN-clause with many elements and possible solutions

2017-07-23 Thread dilaz03 .
Hello. I have database with events with type from different souces identified by id. I have query which filters events by IN-clause with many ids (1-500 ids). I see poor perfomance of IN-clause and try to investigate this problem. SELECT version();

[GENERAL] Planner statistics usage for composite type

2017-07-19 Thread dilaz03 .
Hello. I am trying to find workaround for cross-column statistics. For example, I have tags with similarity: select version(); version