G'day,
This may be way off your problem, and in fact may not matter at all,
but I am led to believe that :
On 21/05/2009, at 4:39 PM, Kis János Tamás wrote:
I have a big table (with 21000 rows):
CREATE TABLE kecskemet_k.foldreszletek
( sorszam bigserial NOT NULL,
hrsz text,
geometria geometry --POLYGON
) WITH (OIDS=TRUE);
CREATE INDEX i_foldreszletek_geometria ON kecskemet_k.foldreszletek
USING gist (geometria);
1. it is better practice to add the geometry column to the table after
generating the table using the postgis addGeometryColumn() function.
2. you may be better to add a gid column than using OIDS
So your table creation might end up looking like :
CREATE TABLE kecskemet_k.foldreszletek
( gid serial unique,
sorszam bigserial NOT NULL,
hrsz text
);
SELECT
AddGeometryColumn
('kecskemet_k','foldreszletek','geometria',-1,'POLYGON',2);
CREATE INDEX i_foldreszletek_geometria ON kecskemet_k.foldreszletek
USING gist (geometria);
I hope this is correct and not unhelpful.
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
[email protected]
Out here, it pays to
know...
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
