[Tile-serving] [osm2pgsql-dev/osm2pgsql] Some research on middle performance (Issue #2110)

[Jochen Topf]

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/2572833204 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250106/22fc01d7/attachment.htm>