I just noticed this old thread.
Thomas Kellerer wrote:
> > 62.1. Introduction
> > ...
> > "A block range is a group of pages that are physically adjacent in the
> > table; for each block range, some summary info is stored by the index."
> >
> > From the above, may I presume that it is best to
Melvin Davidson schrieb am 23.01.2016 um 16:27:
> http://www.postgresql.org/docs/9.5/interactive/brin-intro.html
>
> 62.1. Introduction
> ...
> "A block range is a group of pages that are physically adjacent in the table;
> for each block range, some summary info is stored by the index."
>
>
On 23 January 2016 at 22:41, Vik Fearing wrote:
> On 01/23/2016 10:28 AM, John R Pierce wrote:
>> anyways, yeah, BRIN sounds very cool for very large tables with
>> relatively stable data.
>
> I have found it particularly efficient when the BRIN index contains all
> columns
On 1/23/2016 12:35 AM, Vik Fearing wrote:
>ok, but it doesn't deal with our use case of needing to bulk delete a 6
I can't really parse the end of that sentence, but you are correct that
BRIN does not help at all with partition dropping. Think of it more as
a Seq Scan optimization.
yeah, it
On 01/23/2016 04:42 AM, John R Pierce wrote:
> On 1/22/2016 7:13 PM, David Rowley wrote:
>> 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
On 01/23/2016 10:28 AM, John R Pierce wrote:
> On 1/23/2016 12:35 AM, Vik Fearing wrote:
>>> >ok, but it doesn't deal with our use case of needing to bulk delete a 6
>> I can't really parse the end of that sentence, but you are correct that
>> BRIN does not help at all with partition dropping.
-general-ow...@postgresql.org] On Behalf Of David Rowley
Sent: 23 January 2016 03:14
To: John R Pierce
Cc: PostgreSQL
Subject: Re: [GENERAL] 9.5 new features
On 23 January 2016 at 09:49, John R Pierce <pie...@hogranch.com> wrote:
> one of my coworkers says he thought that 9.5 has some enh
om: pgsql-general-ow...@postgresql.org [mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of David Rowley
> Sent: 23 January 2016 03:14
> To: John R Pierce
> Cc: PostgreSQL
> Subject: Re: [GENERAL] 9.5 new features
>
> On 23 January 2016 at 09:49, John R Pierce <pie...
(sorry to interrupt the discussion on CoC's and social justice, but...)
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
On 23 January 2016 at 09:49, John R Pierce 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
On 1/22/2016 7:13 PM, David Rowley wrote:
On 23 January 2016 at 09:49, John R Pierce 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
11 matches
Mail list logo