Thread: Will auto-cluster be in 7.5?
Is anyone working on these two todo items? # CLUSTER * Automatically maintain clustering on a table * Add way to remove cluster specification on a table
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, Pennsylvania19073
> # 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, Pennsylvania19073
>> 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.