[postgis-users] Re:touches problem

caij at lreis.ac.cn caij at lreis.ac.cn
Thu Nov 15 17:55:19 PST 2007


Thanks for Greg Williamson's answer.I have analyzed my quanbj table.And the analysis result is below:
INFO:  analyzing "public.quanbj1_10000_6_9_fullscreen"
INFO:  "quanbj1_10000_6_9_fullscreen": scanned 3000 of 45260 pages, containing 18570 live rows and 8496 dead rows; 3000 rows in sample, 280159 estimated total rows
And my table DDL is:
CREATE TABLE quanbj1_10000_6_9_fullscreen
(
  ogc_fid int4,
  wkb_geometry geometry,
  quanbeijin numeric(9),
  quanbeij_1 numeric(9),
  id numeric(9),
  "ͼ°ßºÅ" char(7),
  dlm char(4),
  "ȨÊô´úÂë" char(12),
  "ȨÊôÃû³Æ" char(30),
  "ȨÊôÐÔÖÊ" char(3),
  "×ùÂä´úÂë" char(15),
  isadd int2,
  isleaf int2,
  "level" int4,
  lidu float4,
  child_level int2,
  ischanged int2,
  prechanged int2 DEFAULT 0
) 
WITHOUT OIDS;
ALTER TABLE quanbj1_10000_6_9_fullscreen OWNER TO caij;


-- Index: qb_ischanged

-- DROP INDEX qb_ischanged;

CREATE INDEX qb_ischanged
  ON quanbj1_10000_6_9_fullscreen
  USING btree
  (ischanged);

-- Index: qb_leve

-- DROP INDEX qb_leve;

CREATE INDEX qb_leve
  ON quanbj1_10000_6_9_fullscreen
  USING btree
  ("level");

-- Index: qb_lid

-- DROP INDEX qb_lid;

CREATE INDEX qb_lid
  ON quanbj1_10000_6_9_fullscreen
  USING btree
  (lidu);

-- Index: qb_ogc_f

-- DROP INDEX qb_ogc_f;

CREATE INDEX qb_ogc_f
  ON quanbj1_10000_6_9_fullscreen
  USING btree
  (ogc_fid);

-- Index: qb_prechanged

-- DROP INDEX qb_prechanged;

CREATE INDEX qb_prechanged
  ON quanbj1_10000_6_9_fullscreen
  USING btree
  (prechanged);

-- Index: qb_wkb_geometry

-- DROP INDEX qb_wkb_geometry;

CREATE INDEX qb_wkb_geometry
  ON quanbj1_10000_6_9_fullscreen
  USING gist
  (wkb_geometry);




More information about the postgis-users mailing list