ODP: Planner performance in partitions

2019-08-12 Thread Piotr Włodarczyk
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

ODP: Planner performance in partitions

2019-08-12 Thread Piotr Włodarczyk
@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