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

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Postgresql 12, 512 partition by hash. Slow select
Дата
Msg-id 0c671763-526d-0628-6c7f-093b87889a90@a-kretschmer.de
обсуждение исходный текст
Ответ на Postgresql 12, 512 partition by hash. Slow select  (Arya F <arya6000@gmail.com>)
Список 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




В списке pgsql-performance по дате отправления:

Предыдущее
От: Arya F
Дата:
Сообщение: Postgresql 12, 512 partition by hash. Slow select
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql 12, 512 partition by hash. Slow select