[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Large geometry needs a lot of time to be inserted
From: "Jean David TECHER" <davidtecher () yahoo ! fr>
Date: 2005-05-27 13:01:18
Message-ID: 000901c562bc$2caee400$117fa8c0 () jenna
[Download RAW message or body]
What is it these multipolygon???
USA map ???
---------------------------------------------------------------
TECHER Jean David
01MAP
e-mail: david@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@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@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2800.1498" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>What is it these
multipolygon???</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>USA map ???</FONT></DIV>
<DIV>---------------------------------------------------------------<BR>TECHER
Jean David<BR>01MAP<BR>e-mail: <A
href="mailto:david@01map.net">david@01map.net</A><BR>Tél: 04 67 45 60
27<BR>Entreprise: <A
href="http://www.01map.net">http://www.01map.net</A><BR>Perso: <A
href="http://techer.pascal.free.fr/postgis/">http://techer.pascal.free.fr/postgis/</A><BR>---------------------------------------------------------------</DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff \
2px solid; MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt arial">----- Original Message \
----- </DIV> <DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=luaces@enxenio.es href="mailto:luaces@enxenio.es">Miguel R.
Luaces</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=postgis-users@postgis.refractions.net
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A> \
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, May 27, 2005 1:23 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [postgis-users] Large geometry
needs a lot of time to be inserted</DIV>
<DIV><BR></DIV>Dear all,<BR><BR>we have insertedd a very large geometry in a
PostGIS database, and it has <BR>needed an awful lot of
time.<BR><BR>Particularly, the geometry is a multipolygon with 308986 points,
and it has <BR>needed 5803313 ms (over 90 minutes) in a modern computer (don't
remember the <BR>specs, but it is Pentium IV with 1 GB RAM).<BR><BR>Is this
normal? Are we doing something wrong?<BR><BR>Version
information:<BR><BR>PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC
gcc.exe (GCC) 3.4.2 <BR>(mingw-special)<BR>"0.9 USE_GEOS=1 USE_PROJ=1
USE_STATS=1"<BR><BR>Thank you very much in advance. Best regards,<BR>
Miguel<BR><BR>--
<BR>===================================================================<BR>Dr.
Miguel R. Luaces <A
href="mailto:luaces@enxenio.es">luaces@enxenio.es</A><BR>Enxenio
SL \
<A href="http://www.enxenio.es">http://www.enxenio.es</A><BR>Estrada dos Baños
de Arteixo, Edif. San Cristovo, Portal B, 2º Esq.<BR>15008 A Coruña
(Spain) Tlf./Fax.: 981 913
768<BR>===================================================================
<BR><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR><A \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis. \
refractions.net/mailman/listinfo/postgis-users</A><BR></BLOCKQUOTE></BODY></HTML>
_____________________________________________________________________________
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails, photos et vidéos !
Créez votre Yahoo! Mail sur http://fr.mail.yahoo.com
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic