[GMOD-devel] Re: [Gmod-schema] using CLUSTER on tables

[Allen D. <all...@uc...>]

does no one care about this?  i can add an optional file with CLUSTER
statements if there is opposition to putting this in the main DDL.

-Allen

On Sat, 19 Jun 2004, Allen Day wrote:

> hey,
> 
> i have been playing with the postgres CLUSTER function lately on some big
> (>150,000,000) row tables, and it's able to reduce my query time from 1-3
> orders of magnitude if the planner is able to utilize a CLUSTERed index.  
> it speeds up because the rows in the table are reordered on physical disk
> in the order of the index, making for faster-than-random-access lookups
> and better use of file caching.  more information on CLUSTER here:
> 
> http://www.postgresql.org/docs/current/static/sql-cluster.html
> 
> i'm interested in adding sensible CLUSTER calls to the DDL for the
> expression/rad module.  are there objections to this?  any interest in
> using CLUSTER on any of the other modules?  would it be better to put
> these commands in a separate DDL file?
> 
> i'm curious to see if the benchmarks Simon performed a while ago for
> gbrowse improve after clustering on the feature table's R-tree index.
> 
> -Allen
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
> Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
> Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
> REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
> _______________________________________________
> Gmod-schema mailing list
> Gmo...@li...
> https://lists.sourceforge.net/lists/listinfo/gmod-schema
>