How to remove CLUSTERs and 'partitioning tables'

From: Gabriele Bartolini <gbartolini(at)optusnet(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: How to remove CLUSTERs and 'partitioning tables'
Date: 2003-09-15 00:34:46
Message-ID: 1063586085.2187.6.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys,

just a quick and probably stupid question. When I make a cluster
based on an index on a table, how can I remove it later? Should I
'create' a new one by using the primary key index?

Also, can I have more than 1 cluster on my table? Let me explain ...
can I put for instance the record with, let's say, age between 10 and 20
on a specific cluster, from 20 to 30 on another one, and so on?

Thank you
-Gabriele

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Keow Yeong Huat Joseph 2003-09-15 01:04:02 function call
Previous Message Stephan Szabo 2003-09-15 00:27:14 Re: case-insensitive database