Re: Question about paritioning

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about paritioning
Date: 2017-07-27 08:36:01
Message-ID: 0311cf56-785e-474a-5ac5-cca2580f3ce4@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message vinny 2017-07-27 10:05:37 Re: Row based permissions: at DB or at Application level?
Previous Message Thomas Güttler 2017-07-27 08:27:40 Re: Row based permissions: at DB or at Application level?