maintain_cluster_order_v5.patch

Поиск
Список
Период
Сортировка
От phb07@apra.asso.fr
Тема maintain_cluster_order_v5.patch
Дата
Msg-id 20091019193218.DA7964B1C71@smtp2-g21.free.fr
обсуждение исходный текст
Ответы Re: maintain_cluster_order_v5.patch  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-performance
Hi all,

The current discussion about "Indexes on low cardinality columns" let me discover this
"grouped index tuples" patch (http://community.enterprisedb.com/git/) and its associated
"maintain cluster order" patch (http://community.enterprisedb.com/git/maintain_cluster_order_v5.patch)

This last patch seems to cover the TODO item named "Automatically maintain clustering on a table".
As this patch is not so new (2007), I would like to know why it has not been yet integrated in a standart version of PG
(notwell finalized ? not totaly sure ? not corresponding to the way the core team would like to address this item ?)
andif there are good chance to see it committed in a near future. 

I currently work for a large customer who is migrating a lot of databases used by an application that currently largely
takesbenefit from well clustered tables, especialy for batch processing. The migration brings a lot of benefits. In
fact,the only regression, compared to the old RDBMS, is the fact that tables organisation level decreases more quickly,
generatingmore frequent heavy cluster operations.  

So this "maintain cluster order" patch (and may be "git" also) should fill the lack. But leaving the way of the
"standartPG" is not something very attractive... 

Regards.
Philippe Beaudoin.





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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Partitioned Tables and ORDER BY
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: maintain_cluster_order_v5.patch