Re: clustered indexes?

On Wed, 19 Jun 2002, Varun Kacholia wrote:

>    Are clusttered indexes available in PostgreSQL?

No. However, you can achieve a similar effect to clustered indexes by
using the CLUSTER command. (Be careful about your indexes, etc.)

The disadvantage here is that new data doesn't go to the "right
place" in the physical layout of the table. But you can always
re-CLUSTER again.

BTW, clustered indexes would be a *really* cool feature to have in
postgres. I recently saw a query go from 70 seconds down to .6 seconds
when I clustered the table on the particular column I was selecting a
value from.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC