I did some further tests regarding VACUUM:
* When I run `VACUUM tablename;` after a `COPY FREEZE` the vacuum needs about
half a second, so apparently is doesn't have to do anything.
* After a normal `COPY` of the ways table (done in 55 minutes), it takes nearly
7 minutes to run the `VACUUM tablename;`
So not only is the `COPY FREEZE` itself faster, it spares use the vacuum time.
Normally we don't see that time, because it will hit us randomly a bit later
when the autovacuum kicks in.
--
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/issues/2110#issuecomment-2572833204
You are receiving this because you are subscribed to this thread.
Message ID: <osm2pgsql-dev/osm2pgsql/issues/2110/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving
