search

mediagis / nominatim-docker

100% working container for Nominatim
Creative Commons Zero v1.0 Universal
1.08k stars 442 forks source link

Upgrade PostgreSQL from 14 to 15 #401

Open IvanShift opened 1 year ago

IvanShift commented 1 year ago

Hello! PostgreSQL v15 significantly speeds up the most common operations:

In this latest release, PostgreSQL improves on its in-memory and on-disk sorting algorithms, with benchmarks showing speedups of 25% - 400% based on which data types are sorted.

I suppose it will be useful.

philipkozeny commented 1 year ago

Sounds interesting, thanks. This will come in handy as soon as Ubuntu releases a new LTS with PostgreSQL 15 and there is a new Nominatim version, since we don't do PostgreSQL upgrades in our container without a new release.

IvanShift commented 1 year ago

Nominatim 4.2 has already supported PostgreSQL 15: https://github.com/osm-search/Nominatim/blob/master/ChangeLog

leonardehrenfried commented 1 year ago

It's not like we don't want to use PG 15, btw. We just don't want to take on the extra maintenance burden of using a version that isn't in the default repos of our base image.

IvanShift commented 1 year ago

Hello! Ubuntu 23.04 is out: https://www.omgubuntu.co.uk/2023/03/ubuntu-23-04-features It has postgresql-15 in the repository Can you update PostgreSQL from 14 to 15 ?

dsperling commented 1 year ago

@IvanShift - There is a Docker Nominatim project we have started that might be of interest. n7m is a Numeronym for Nominatim. The project supports connecting the Nominatin App to a Postgres database running in a different container.

This branch supports Postgres 15: https://github.com/smithmicro/n7m/tree/feature/psql15

This is where Postgres 15 is specified: https://github.com/smithmicro/n7m/blob/0bcd719b753bb404270288077fec16b1b331bff8/gis/Dockerfile#L1

philipkozeny commented 4 months ago

FYI: Ubuntu 24.04 LTS will be released shortly and includes PostgreSQL 16 in its packages.

root@620dbdd4c7c9:/# apt info postgresql-16
Package: postgresql-16
Version: 16.2-1ubuntu4

With the next major Nominatim update (e.g., 4.5 or 5.x), we also aim to switch to Ubuntu 24.04 LTS, therefore running PG16. Version 4.4.x will stay on 22.04 for now.