[OSM-dev] Osmosis error, duplicate

Joachim Zobel jz-2008 at heute-morgen.de
Fri Jun 5 18:29:15 BST 2009


Am Freitag, den 05.06.2009, 12:40 -0400 schrieb Jeffrey Warren:
> and it's been running the following query for about 24 hours: 
> 
> SELECT Count(*) AS changesetCount FROM changesets WHERE id=$1 

Take a look on Brets pgsql-latest.sql script (after the COPYs) and add
the index on id:

ALTER TABLE ONLY changesets
    ADD CONSTRAINT pk_changesets PRIMARY KEY (id);

Sincerely,
Joachim







More information about the dev mailing list