On 10/5/2011 8:52 AM, Andreas Forø Tollefsen wrote:
Hi all,
I have a query that previously have been running without problems.
However, after installing everything from scratch it no longer work.
Ubuntu 11.04, Postgresql 8.4.8, PostGIS 2.0 (7932), Geos 3.3.1, GDAL 1.8.1.
The script measures distances from centroids of a vector grid to the
nearest international border to a neighboring country.
It uses psycopg2 module in python to loop through the years. So it
inserts the distances for each year into the borddist table.
However, the problem after the reinstall is that it usually loops
through some years, and then everything stops. The usual processing time
is ~20 minutes per year.
Could this be a memory issue in postgresql.conf? Or is there a problem i
am not aware of? This used to work on the previous installation, but we
wanted to update the server to latest.
Can you check the PG logs and see if there are errors? When you say
everything stops, is there a postgres process still running? Is it
blocked?
Have you tried:
select * from pg_locks;
and
select * from pg_stat_activity;
Is PG using CPU time? or does it really crash?
-Andy
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
