[Tile-serving] [openstreetmap/osm2pgsql] Postgresql ANALYZE on each update ? (#1556)

Mon Aug 23 10:06:34 UTC 2021

## What version of osm2pgsql are you using?

2021-08-23 10:00:15  osm2pgsql version 1.4.1
Compiled using the following library versions:
Libosmium 2.16.0
Proj [API 4] Rel. 6.3.1, February 10th, 2020
Lua 5.3.3

Since https://github.com/openstreetmap/osm2pgsql/commit/5d1a941921f70b39a1cb6afbf8c6cf2258e457b7 osm2pgsql updates are doing an ANALYZE on ways and rels tables at every run.

Is this really necessary on each updates ?

It looks fine on initial import, then during DB maintenance (where a larger default_statistics_target is a good idea to get better statistics).

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/1556
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210823/0fe075ea/attachment.htm>