osm2pgsql

osm2pgsql copied to clipboard

Logging falsely suggests CLUSTER is run

2

## What version of osm2pgsql are you using? osm2pgsql v1.5.1 ## What operating system and PostgreSQL/PostGIS version are you using? Ubuntu 20.04.1 LTS, PostgreSQL 13.4 / PostGIS 3.1.3 ## Tell...

mboeringa

Default value for `--cache`

6

The default value for the `--cache/-C` parameter is currently 800 which is rather small for current hardware and typical use. * Do we want a larger default value? * Do...

joto

WIP: Experimental middle implementations

1

This PR adds two new middle implementations: - `db` is similar to `pgsql`. All data is stored in the database. A new table structure with JSONB for tags and relation...

joto

Use SP-GiST indexes when available

9

Since PostGIS 2.5 and PostgreSQL 11, spgist indexes are available for 2d and 3d geometries. PostGIS performance testing [indicates they are beneficial with many overlapping objects.](https://postgis.net/docs/using_postgis_dbmanagement.html#spgist_indexes) This is the situation...

pnorman

Add options to skip geometry indexes and ordering

8

Currently osm2pgsql always creates geometry indexes and orders the tables by geometry, essentially clustering them. There are cases where this is not desirable. 1. Benchmarking of other parts. 2. Analysis...

pnorman

Planning for backwards incompatible changes

7

At some point in the not too far future (**not** the next version as I write this) we want to make a backwards incompatible change to the pgsql middle which...

joto

Possible improvements for new ram middle

5

The new ram middle (#1461) is better than the previous implementations but there are several places where it could be made even better. Here are some ideas that we can...

joto

Flex backend : mark_node ?

6

Hello, I'm trying to use the new flex backend in order to retrieve street name from an associatedStreet relation to add it to all nodes being a member of relation....

PanierAvide

Deprecating gazetteer output

1

With the flex output, there is no need to have a separate gazetteer output, as it allows to configure most of what we need. This tickets collects the features that...

lonvia

Suggestion: middle-pgsql stats for hit/miss

1

If any node in a way is not in the cache, then the cost of the `local_nodes_get_list` becomes the cost of a database access. The difference between a db access...

tiedotguy