Re: [GENERAL] Question about paritioning - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] Question about paritioning
Date
Msg-id 0311cf56-785e-474a-5ac5-cca2580f3ce4@hogranch.com
Whole thread Raw
In response to Re: [GENERAL] Question about paritioning  (Alex Samad <alex@samad.com.au>)
Responses Re: [GENERAL] Question about paritioning
List 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 by date:

Previous
From: Thomas Güttler
Date:
Subject: Re: [GENERAL] Row based permissions: at DB or at Application level?
Next
From: vinny
Date:
Subject: Re: [GENERAL] Row based permissions: at DB or at Application level?