From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 9.5 new features |
Date: | 2016-01-23 03:42:26 |
Message-ID: | 56A2F6A2.1060700@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1/22/2016 7:13 PM, David Rowley wrote:
> On 23 January 2016 at 09:49, John R Pierce<pierce(at)hogranch(dot)com> wrote:
>> >one of my coworkers says he thought that 9.5 has some enhancements in
>> >partitioning, but looking at the release notes I don't see anything specific
>> >? do BRIN's play into partitioned tables ?
>> >
>> >in our case, we partition very large 'event' tables by week with 6 month
>> >retention....
> BRIN can be seen as a form of "automatic partitioning", and I have
> seen it described as such in documents relating to the BRIN project,
> so perhaps that description has made its way further afield and that's
> maybe what your coworker heard about.
>
> If you view the inheritance partitioning feature as a method of
> eliminating scans of partitions which can be proved unneeded at
> planning time, then BRIN can eliminate blocks from a scan of a single
> relation (or rather "pages_per_range") during execution time. So I
> agree with the "automatic partitioning" description.
ok, but it doesn't deal with our use case of needing to bulk delete a 6
--
john r pierce, recycling bits in santa cruz
From | Date | Subject | |
---|---|---|---|
Next Message | John J. Turner | 2016-01-23 04:40:45 | Re: Connecting to SQL Server from Windows using FDW |
Previous Message | David Rowley | 2016-01-23 03:13:43 | Re: 9.5 new features |