Will auto-cluster be in 7.5?

Joseph Shraibman wrote:

Is anyone working on these two todo items?

# CLUSTER

* Automatically maintain clustering on a table

No, and we don't know how to do it.

* Add way to remove cluster specification on a table

This patch is done and will be applied soon.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

# CLUSTER

* Automatically maintain clustering on a table
* Add way to remove cluster specification on a table

I've done the latter - it's been sent to -patches. However, I need
someone to look at the shift/reduce problem I'm getting...

Chris

Bruce Momjian wrote:

Joseph Shraibman wrote:

* Add way to remove cluster specification on a table

This patch is done and will be applied soon.

I'm a bit confused, why would you want to uncluster a table?

Joseph Shraibman wrote:

Bruce Momjian wrote:

Joseph Shraibman wrote:

* Add way to remove cluster specification on a table

This patch is done and will be applied soon.

I'm a bit confused, why would you want to uncluster a table?

Because a CLUSTER with no argument clusters all previously clustered
tables in the db. This turns it off for that table.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

This patch is done and will be applied soon.

I'm a bit confused, why would you want to uncluster a table?

You would want to remove the marker that says 'cluster this column in
the future'. At the moment, there is no way of removing all markers
from a table.

Chris

Bruce Momjian wrote:

Because a CLUSTER with no argument clusters all previously clustered
tables in the db. This turns it off for that table.

My bad, I should have read the docs more closely.