> There is only a single version of postgresql & postgis in the Debian stable
> repos, pgdg packages are not used.
>
> > - Can you check the PostGIS selectivity estimate on the old and the
> > new installations, using
> >
> > SELECT _postgis_selectivity ('nodes', 'geom',
> > ST_GeomFromEWKT('SRID=4326;POLYGON((6.11982 52.6121955,6.11982
> > 53.2038323,7.0927397 53.2038323,7.0927397 52.6121955,6.11982
> > 52.6121955))'), '2');
>
> I cannot test this easily on the old installation, I'd need to load the data
> in
> bookworm chroot on that system which is very time consuming.
>
> For the new installation:
>
> osm-nl=# SELECT _postgis_selectivity ('nodes', 'geom',
> ST_GeomFromEWKT('SRID=4326;POLYGON((6.11982 52.6121955,6.11982
> 53.2038323,7.0927397 53.2038323,7.0927397 52.6121955,6.11982
> 52.6121955))'), '2'); _postgis_selectivity
> ----------------------
> 0
> (1 row)
>
Bas,
Can you get us a small dump of the data showing the issue or the recipe you
used to load the data?
I'd like to try this out on a couple of versions of PG/ PostGIS I have loaded.
