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
