How to remove CLUSTERs and 'partitioning tables' - Mailing list pgsql-general

From Gabriele Bartolini
Subject How to remove CLUSTERs and 'partitioning tables'
Date
Msg-id 1063586085.2187.6.camel@localhost
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: case-insensitive database
Next
From: "Keow Yeong Huat Joseph"
Date:
Subject: function call