Re: On columnar storage (2)

Поиск
Список
Период
Сортировка
От Haribabu Kommi
Тема Re: On columnar storage (2)
Дата
Msg-id CAJrrPGcuCvfKcvYACRcTbkJS2Ym87YW-2JEo1QvuOR4LOfm-6w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: On columnar storage (2)  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: On columnar storage (2)  (Bert <biertie@gmail.com>)
Список pgsql-hackers
On Mon, Feb 1, 2016 at 12:11 AM, Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
> So we discussed some of this stuff during the developer meeting in
> Brussels and the main conclusion is that we're going to split this up in
> multiple independently useful pieces, and write up the general roadmap
> in the wiki so that we can discuss in detail on-list.
>
> I'm marking this as Returned with Feedback now.
>
> Thanks everybody,

Here I attached the DBT-3 performance report that is measured on the
prototype patch
that is written for columnar storage as I mentioned in my earlier mail
with WOS and ROS
design.

Currently to measure the benefits of this design, we did the following changes,
1. Created the columnar storage index similar like other index methods
2. Used custom plan to generate the plan that can use the columnar storage
3. Optimized parallelism to use the columnar storage

The code is not fully ready yet, I posted the performance results to
get a view from
community, whether this approach is really beneficial?

I will provide the full details of the design and WIP patches later.

Regards,
Hari Babu
Fujitsu Australia

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: WIP: Upper planner pathification
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system