Changes between Version 3 and Version 4 of Parcours source RHT

Timestamp:

Oct 25, 2011 10:33:22 PM (14 years ago)

Author:

cedric

Comment:

--

Parcours source RHT

@@ -6 +6 @@
 -- script de calcul des distances sources
 set search_path to rht,public;
-select cast(ltree2text(subltree(chemin,0,1)) as integer) from rht_topology 
+select cast(ltree2text(subltree(chemin,0,1)) as integer) from rht_topology limit 10
 /*
 AJOUT D'UN INDEX
@@ -13 +13 @@
     GiST index over ltree: <, <=, =, >=, >, @>, <@, @, ~, ? 
 */
+CREATE INDEX chemin_btee_index ON rht.rht_topology USING btree(chemin); --27688 ms
+VACUUM ANALYSE rht.rht_topology;
 CREATE INDEX chemin_gist_index ON rht.rht_topology USING GIST (chemin); -- fait planter mon serveur....
+SELECT chemin from rht.rht_topology where chemin <@ '212340'; -- tronçon source de la Vilaine -- 2360
 }}}