[Tile-serving] [openstreetmap/osm2pgsql] Call ANALYZE on tables with ids when two-stage processing is used (PR #1675)

[Jochen Topf]

@mboeringa No. ANALYZE collects statistics. Whether there is an index or not isn't relevant for that. The planner uses those stats and the information about indexes when planning, not somehow when ANALYZE is run.

I am running ANALYZE before the CREATE INDEX on the off chance that the index building can somehow be done in a better way with better statistics, although I don't believe that that's the case.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/pull/1675#issuecomment-1134279725
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/osm2pgsql/pull/1675/c1134279725 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20220523/9eb70997/attachment.htm>