[postgis-users] Server not responding
andy at squeakycode.net
Wed Oct 5 07:40:21 PDT 2011
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
Have you tried:
select * from pg_locks;
select * from pg_stat_activity;
Is PG using CPU time? or does it really crash?
More information about the postgis-users