Re: 9.5 new features

Поиск
Список
Период
Сортировка
От FarjadFarid\(ChkNet\)
Тема Re: 9.5 new features
Дата
Msg-id 002c01d155cb$bb4fdb70$31ef9250$@checknetworks.com
обсуждение исходный текст
Ответ на Re: 9.5 new features  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: 9.5 new features
Список pgsql-general
Sounds like a great feature.

How can it be tested?

I am particularly thinking of window servers and effect of this on a live system and any performance issues.

It is an exciting feature. Thanks guys.


-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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 <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
theBRIN 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
unneededat planning time, then BRIN can eliminate blocks from a scan of a single relation (or rather "pages_per_range")
duringexecution time. So I agree with the "automatic partitioning" description. 

--
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



В списке pgsql-general по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: 9.5 new features
Следующее
От: "John J. Turner"
Дата:
Сообщение: Re: Connecting to SQL Server from Windows using FDW