Re: [GENERAL] Question about paritioning

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: [GENERAL] Question about paritioning
Дата
Msg-id 0311cf56-785e-474a-5ac5-cca2580f3ce4@hogranch.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Question about paritioning  (Alex Samad <alex@samad.com.au>)
Ответы Re: [GENERAL] Question about paritioning
Список pgsql-general
On 7/27/2017 12:43 AM, Alex Samad wrote:
>
> ... as long as the queries stay on a small amount of parts that we
> should be okay.

thats true as long as the planner can restrict the queries to the
correct partition...  but there's lots of queries that end up having to
hit all partitions because the planner can't guess correctly.


--
john r pierce, recycling bits in santa cruz



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

Предыдущее
От: Thomas Güttler
Дата:
Сообщение: Re: [GENERAL] Row based permissions: at DB or at Application level?
Следующее
От: vinny
Дата:
Сообщение: Re: [GENERAL] Row based permissions: at DB or at Application level?