Am 05.04.20 um 19:48 schrieb Arya F:
Am I missing something in my setup? Or is this expected? I do know having more than 100 partitions in prior versions of PostgreSQL 12 would cause a major slow down, but from what I read PostgreSQL 12 addresses that now?
to say more about your problem we need to know more. For instance, the exact table definition, the query and the execution plan (explain analyse ...).
Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com