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 c
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."
>
> Fro
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 wrot
-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 wrote:
> one of my coworkers says he thought that 9.5 has some enhancements in
> partitionin
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 of the table. Just usi
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. Thi
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 w
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 t
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 partitioned tables ?
>
>in o
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 partition very large 'event'
10 matches
Mail list logo
