As you wrote we have about 400/500 partitions in real life. So time problem is
much smaller, but still it is and in one place of aur application we have
decided to help DB and we're indicating in query exact partition we need. What
pushed me to do this test? Just curiosity I think. After I saw i
@Michael Lewis: I know documentation. I'm just considerations about possible
performance tricks in current production version. I've tested this on V12 on
another computer and I can say that I'm impressed. I've checked on 1200
partitions and times are:
PostgreSQL11.5:
• select on main partition