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 _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev