Your message dated Mon, 30 Mar 2009 14:12:58 +0200
with message-id <20090330121257.ga4...@mithrandir>
and subject line This seems a local problem
has caused the Debian Bug report #502186,
regarding postgis ST_SPHEROID_LENGTH slow
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)
--
502186: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=502186
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems
--- Begin Message ---
Package: postgis
Version: 1.3.3-3
Since debian testing introduced postgresql-8.3 and postgis 1.3.3 for
postgresql-8.3. The problem I am facing is that length_spheroid is much
slower in postgres-8.3 from under 1s to about 60s (See Bellow).
Both databases are equal, tested in same machine, with different
installations to avoid software versions conflicts.
FIRST:
postgresql-8.2 (version 8.2.7-2+b1) with postgis (version 1.3.2-1)
EXPLAIN ANALYSE select length_spheroid(geom,'SPHEROID["WGS
84",6378137,298.257223563]') FROM test order by id limit 100;
QUERY
PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.00..17.44 rows=100 width=26054) (actual
time=1.852..588.394 rows=100 loops=1)
-> Index Scan using test_pkey on test (cost=0.00..2268.52
rows=13010 width=26054) (actual time=1.850..588.298 rows=100 loops=1)
Total runtime: 588.495 ms
(3 rows)
SECOND:
postgresql-8.3 (version 8.3.4-1) with postgis (version 1.3.3-3)
EXPLAIN ANALYSE select length_spheroid(geom,'SPHEROID["WGS
84",6378137,298.257223563]') FROM test order by id limit 100;
QUERY
PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.00..11.07 rows=100 width=36) (actual
time=219.032..59913.512 rows=100 loops=1)
-> Index Scan using test_pkey on tracker_track (cost=0.00..1439.93
rows=13010 width=36) (actual time=219.029..59913.377 rows=100 loops=1)
Total runtime: 59913.701 ms
(3 rows)
--- End Message ---
--- Begin Message ---
Package: postgis
Severity: normal
Version: 1.3.5-1
On the basis of the related thread on postgis-users, I would close
this report.
http://postgis.refractions.net/pipermail/postgis-users/2008-September/021351.html
Feel free to re-open if you had more information.
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-1-686 (SMP w/1 CPU core)
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
--
Francesco P. Lovergine
--- End Message ---
_______________________________________________
Pkg-grass-devel mailing list
Pkg-grass-devel@lists.alioth.debian.org
http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-devel
