planet_osm_line bloat...

[cquest]

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 ?

[joto]

Bloat is "created" when things change. So I would assume that that's because there are more changes to the line table than to other tables.

[cquest]

That's a plausible explanation !