[Tile-serving] [osm2pgsql] process blocked after planet_osm_roads is indexed (#174)

[kytay]

SELECT * FROM pg_stat_activity;

gives

 12896 | postgres | 7096 |       10 | postgres |                       |               |                 |          -1 | 2014-08-06 19:47:14.164574+08 | 2014-08-06 19:48:05.786197+08 | 2014-08-06 19:48:05.786197+08 | 2014-08-06 19:48:05.786199+08 | f       | active | SELECT * FROM pg_stat_activity;
 16385 | gis      | 6797 |       10 | postgres | pgAdmin III - Browser | 172.30.93.23  |                 |       27771 | 2014-08-06 18:16:57.580807+08 | 2014-08-06 18:18:02.704166+08 | 2014-08-06 18:18:02.704166+08 | 2014-08-06 18:18:02.704167+08 | f       | active | SELECT count(*) AS rows FROM ONLY public.planet_osm_nodes
 16385 | gis      | 2485 |    16384 | gisuser  |                       | 172.30.92.211 |                 |       56962 | 2014-07-25 19:58:28.344257+08 | 2014-08-05 23:00:43.842073+08 | 2014-08-05 23:00:43.842073+08 | 2014-08-05 23:00:43.842075+08 | f       | active | CREATE TABLE planet_osm_line_tmp AS SELECT * FROM planet_osm_line ORDER BY way;
 16385 | gis      | 2486 |    16384 | gisuser  |                       | 172.30.92.211 |                 |       56963 | 2014-07-25 19:58:28.436312+08 | 2014-08-05 23:03:18.051379+08 | 2014-08-05 23:03:18.051379+08 | 2014-08-05 23:03:18.051381+08 | f       | active | CREATE TABLE planet_osm_polygon_tmp AS SELECT * FROM planet_osm_polygon ORDER BY way;
 16385 | gis      | 2489 |    16384 | gisuser  |                       | 172.30.92.211 |                 |       56966 | 2014-07-25 19:58:28.722288+08 | 2014-08-05 22:45:03.531047+08 | 2014-08-05 22:45:03.531047+08 | 2014-08-05 22:45:03.531049+08 | f       | active | CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes)  WITH (FASTUPDATE=OFF);


---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/174#issuecomment-51291398
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20140805/bba2443c/attachment.html>