Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 12, 512 partition by hash. Slow select - Mailing list pgsql-performance

From Andreas Kretschmer
Subject Re: Postgresql 12, 512 partition by hash. Slow select
Date
Msg-id 0c671763-526d-0628-6c7f-093b87889a90@a-kretschmer.de
Whole thread Raw
In response to Postgresql 12, 512 partition by hash. Slow select  (Arya F <arya6000@gmail.com>)
List pgsql-performance
Tree view 

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

pgsql-performance by date:

Previous
From: Arya F
Date:
Subject: Postgresql 12, 512 partition by hash. Slow select
Next
From: Tom Lane
Date:
Subject: Re: Postgresql 12, 512 partition by hash. Slow select