Large geometry needs a lot of time to be inserted

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Large geometry needs a lot of time to be inserted

Miguel R. Luaces
Dear all,

we have insertedd a very large geometry in a PostGIS database, and it has
needed an awful lot of time.

Particularly, the geometry is a multipolygon with 308986 points, and it has
needed 5803313 ms (over 90 minutes) in a modern computer (don't remember the
specs, but it is Pentium IV with 1 GB RAM).

Is this normal? Are we doing something wrong?

Version information:

PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)
"0.9 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"

Thank you very much in advance. Best regards,
  Miguel

--
===================================================================
Dr. Miguel R. Luaces          [hidden email]
Enxenio SL                    http://www.enxenio.es
Estrada dos Baños de Arteixo, Edif. San Cristovo, Portal B, 2º Esq.
15008 A Coruña (Spain)        Tlf./Fax.: 981 913 768
===================================================================

_______________________________________________
postgis-users mailing list
[hidden email]
http://postgis.refractions.net/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Large geometry needs a lot of time to be inserted

David TECHER
What is it these multipolygon???
 
USA map ???
---------------------------------------------------------------
TECHER Jean David
01MAP
e-mail: [hidden email]
Tél: 04 67 45 60 27
Entreprise: http://www.01map.net
Perso: http://techer.pascal.free.fr/postgis/
---------------------------------------------------------------
----- Original Message -----
Sent: Friday, May 27, 2005 1:23 PM
Subject: [postgis-users] Large geometry needs a lot of time to be inserted

Dear all,

we have insertedd a very large geometry in a PostGIS database, and it has
needed an awful lot of time.

Particularly, the geometry is a multipolygon with 308986 points, and it has
needed 5803313 ms (over 90 minutes) in a modern computer (don't remember the
specs, but it is Pentium IV with 1 GB RAM).

Is this normal? Are we doing something wrong?

Version information:

PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)
"0.9 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"

Thank you very much in advance. Best regards,
  Miguel

--
===================================================================
Dr. Miguel R. Luaces          [hidden email]
Enxenio SL                    http://www.enxenio.es
Estrada dos Baños de Arteixo, Edif. San Cristovo, Portal B, 2º Esq.
15008 A Coruña (Spain)        Tlf./Fax.: 981 913 768
===================================================================

_______________________________________________
postgis-users mailing list
[hidden email]
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[hidden email]
http://postgis.refractions.net/mailman/listinfo/postgis-users