Re: 9.5 new features

On 1/22/2016 7:13 PM, David Rowley wrote:
> On 23 January 2016 at 09:49, John R Pierce<pierce@hogranch.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