Re: [GENERAL] 9.5 new features

2016-04-07 Thread Alvaro Herrera
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

Re: [GENERAL] 9.5 new features

2016-01-24 Thread Thomas Kellerer
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." > >

Re: [GENERAL] 9.5 new features

2016-01-23 Thread David Rowley
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

Re: [GENERAL] 9.5 new features

2016-01-23 Thread John R Pierce
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

Re: [GENERAL] 9.5 new features

2016-01-23 Thread Vik Fearing
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

Re: [GENERAL] 9.5 new features

2016-01-23 Thread Vik Fearing
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.

Re: [GENERAL] 9.5 new features

2016-01-23 Thread FarjadFarid(ChkNet)
-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

Re: [GENERAL] 9.5 new features

2016-01-23 Thread Melvin Davidson
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...

[GENERAL] 9.5 new features

2016-01-22 Thread John R Pierce
(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

Re: [GENERAL] 9.5 new features

2016-01-22 Thread David Rowley
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

Re: [GENERAL] 9.5 new features

2016-01-22 Thread John R Pierce
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