[Tile-serving] [openstreetmap/osm2pgsql] Logging falsely suggests CLUSTER is run (#1565)

[mboeringa]

## 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 us something about your system

<!-- How much RAM do you have, how many CPUs, bare metal or cloud setup? -->


## What did you do exactly?

Monitored SQL statements generated by osm2pgsql in pgAdmin.

## What did you expect to happen?

Currently logging suggests **CLUSTER** is run in PostgreSQL, however, in reality an "**ORDER BY way**" statement is used. While the net result of these two options is virtually identical, the suggestion that CLUSTER is run has a side consequence. Any tables that are truly CLUSTERed, can be easily re-clustered using the PostgreSQL [clusterdb utility](https://www.postgresql.org/docs/current/app-clusterdb.html). This is not the case for tables spatially sorted by "ORDER BY way".


## What did happen instead?

<!-- Please describe what happened and why you think this is wrong. Please include
(or link to, if it is too verbose) the log output. -->


## What did you do to try analyzing the problem?

<!-- Describe what steps you already did to try analyzing the problem before
reporting. -->



-- 
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/1565
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20210901/b24583e9/attachment.htm>