Re: Postgresql 12, 512 partition by hash. Slow select

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql 12, 512 partition by hash. Slow select
Date: 2020-04-05 18:41:03
Message-ID: 0c671763-526d-0628-6c7f-093b87889a90@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2020-04-05 18:55:00 Re: Postgresql 12, 512 partition by hash. Slow select
Previous Message Arya F 2020-04-05 17:48:03 Postgresql 12, 512 partition by hash. Slow select