Is anyone working on these two todo items?

# CLUSTER

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

Thu, 18 Mar 2004 17:55:22 -0500
Joseph Shraibman <jks@selectacast.net>
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

Thu, 18 Mar 2004 18:28:22 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Will auto-cluster be in 7.5?
> # 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


Fri, 19 Mar 2004 09:34:57 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Will auto-cluster be in 7.5?
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?


Thu, 18 Mar 2004 23:01:06 -0500
Joseph Shraibman <jks@selectacast.net>
Re: Will auto-cluster be in 7.5?
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

Thu, 18 Mar 2004 23:04:38 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Will auto-cluster be in 7.5?
>> 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

Fri, 19 Mar 2004 12:19:59 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Re: Will auto-cluster be in 7.5?
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.

Thu, 18 Mar 2004 23:49:21 -0500
Joseph Shraibman <jks@selectacast.net>
Re: Will auto-cluster be in 7.5?