Skip site navigation (1) Skip section navigation (2)

Re: maintain_cluster_order_v5.patch

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: "phb07(at)apra(dot)asso(dot)fr" <phb07(at)apra(dot)asso(dot)fr>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: maintain_cluster_order_v5.patch
Date: 2009-10-19 22:05:53
Message-ID: 1255989953.31947.114.camel@monkey-cat.sm.truviso.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, 2009-10-19 at 21:32 +0200, phb07(at)apra(dot)asso(dot)fr wrote:
> 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".

The TODO item isn't clear about whether the order should be strictly
maintained, or whether it should just make an effort to keep the table
mostly clustered. The patch mentioned above makes an effort, but does
not guarantee cluster order.

> 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 (not well
> finalized ? not totaly sure ? not corresponding to the way the core
> team would like to address this item ?) and if there are good chance
> to see it committed in a near future.

Search the archives on -hackers for discussion. I don't think either of
these features were rejected, but some of the work and benchmarking have
not been completed.

If you can help (either benchmark work or C coding), try reviving the
features by testing them and merging them with the current tree. I
recommend reading the discussion first, to see if there are any major
problems.

Personally, I'd like to see the GIT feature finished as well. When I
have time, I was planning to take a look into it.

Regards,
	Jeff Davis


In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2009-10-20 02:50:46
Subject: Re: Performance with sorting and LIMIT on partitioned table
Previous:From: phb07@apra.asso.frDate: 2009-10-19 19:32:18
Subject: maintain_cluster_order_v5.patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group