[postgis-users] Large geometry needs a lot of time to be inserted

[Jean David TECHER]

What is it these multipolygon???

USA map ???
---------------------------------------------------------------
TECHER Jean David
01MAP
e-mail: david at 01map.net
Tél: 04 67 45 60 27
Entreprise: http://www.01map.net
Perso: http://techer.pascal.free.fr/postgis/
---------------------------------------------------------------
  ----- Original Message ----- 
  From: Miguel R. Luaces 
  To: postgis-users at postgis.refractions.net 
  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          luaces at enxenio.es
  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
  postgis-users at postgis.refractions.net
  http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050527/b7555f65/attachment.html>