[Tile-serving] [osm2pgsql-dev/osm2pgsql] planet_osm_line bloat... (Discussion #2439)

[Christian Quest]

On a classic osm2pgsql setup (without flex), I've always seen that the planet_osm_line is the one that accumulates bloat compare to planet_osm_point or planet_osm_polygon.

```
            tablename             | tbloat | wastedbytes 
----------------------------------+--------+-------------
 planet_osm_line                  |    1.5 | 73024176128
 planet_osm_ways                  |    1.2 | 42248388608
 planet_osm_roads                 |    1.0 |   567631872
 planet_osm_rels                  |    1.1 |   533676032

```
Has anybody tried to explain this ?
I imagine it comes from PG/postgis level, not osm2pgsql itself.

Is this something that also happen on flex tables containing linestrings ?

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2439
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2439 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20251212/0d9c7426/attachment.htm>