I am using osm2po to populate a pgrouting-compatible table in a postgis enabled database.
I changed the table definition a little bit (unlogged table for faster inserts, added indexes on osm_id for faster lookups, clustered on way geometry for faster seeks, ...).
I now need to update this table with fresh data. Can I somehow tell osm2po to not include DDL statements to create the table ?
Also, can the
INSERT statements be changed to
COPY for faster inserts ?
My current solution is to
tail -n +13 osm\osm_2po_4pgr.sql to strip the first rows. It's OK, but not the best solution.
As for the
COPY statements, I have no solution yet (replacing in the file would not be worth the computing time I believe).