Re: Equivalent praxis to CLUSTERED INDEX? - Mailing list pgsql-performance

From Gregory S. Williamson
Subject Re: Equivalent praxis to CLUSTERED INDEX?
Date
Msg-id 71E37EF6B7DCC1499CEA0316A256832801D4B6FA@loki.wc.globexplorer.net
Whole thread Raw
In response to Equivalent praxis to CLUSTERED INDEX?  (Mischa Sandberg <mischa.sandberg@telus.net>)
List pgsql-performance
FWIW,

Informix does allow the fragmentation of data over named dbspaces by round-robin and expression; this is autosupporting
aslong as the dba keeps enough space available. You may also fragment the index although there are some variations
dependingon type of Informix (XPS, etc.); this is available in at least 9.3 ... I have never used the index
fragmentationas its own beast, but the fragmenting of data works like a charm for spreadling load over more disks. 

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: Gaetano Mendola [mailto:mendola@bigfoot.com]
Sent: Thursday, August 26, 2004 2:10 PM
To: Bruce Momjian; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Equivalent praxis to CLUSTERED INDEX?


Bruce Momjian wrote:
> How do vendors actually implement auto-clustering?  I assume they move
> rows around during quiet periods or have lots of empty space in each
> value bucket.
>
> ---------------------------------------------------------------------------

IIRC informix doesn't have it, and you have to recluster periodically
the table. After having clustered the table with an index in order to
recluster the table with another index you have to release the previous
one ( ALTER index TO NOT CLUSTER ), the CLUSTER is an index attribute and
each table can have only one index with that attribute ON.


Regards
Gaetano Mendola



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Equivalent praxis to CLUSTERED INDEX?
Next
From: Bruce Momjian
Date:
Subject: Re: Equivalent praxis to CLUSTERED INDEX?