polastre commented on issue #726: URL: https://github.com/apache/incubator-baremaps/issues/726#issuecomment-1644404380
Thanks for the quick response. Here's a rundown of the setup, and then the output you requested. I'm running baremaps 0.7.1 locally, connecting to a postgis database container running in docker. For export, I run the following command: ``` baremaps map export --tileset="./data/tileset.json" --database="jdbc:postgresql://localhost:9001/baremaps?&user=baremaps&password=baremaps" --repository="./data/tiles" ``` The input data is a subset of the [OSM export for the state of Texas](https://download.geofabrik.de/north-america/us/texas-latest.osm.pbf), limited to administrative boundaries and information about roads and airports. Almost all of the tileset definitions are of the form: ``` SELECT id, tags, geom FROM osm_ways WHERE tags ? 'aeroway' AND tags ->> 'aeroway' = 'runway' ``` There are indices on `tags` and `geom` for all the `osm_*` tables, like `osm_ways`. When running the export command, you can see how long it takes: ``` [INFO ] 2023-07-20 17:57:27.967 [main] ExportVectorTiles - Exporting vector tiles from jdbc:postgresql://localhost:9001/baremaps?&user=baremaps&password=baremaps to /home/joe.polastre/git/basemap-tiles/./data/tiles [INFO ] 2023-07-20 17:57:27.972 [main] HikariDataSource - HikariPool-1 - Starting... [INFO ] 2023-07-20 17:57:28.126 [main] HikariPool - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@7fc6de5b [INFO ] 2023-07-20 17:57:28.127 [main] HikariDataSource - HikariPool-1 - Start completed. [INFO ] 2023-07-20 17:57:33.280 [ForkJoinPool.commonPool-worker-20] ProgressLogger - 0.0% [INFO ] 2023-07-20 17:57:38.329 [ForkJoinPool.commonPool-worker-8] ProgressLogger - 0.0% [INFO ] 2023-07-20 17:57:43.350 [ForkJoinPool.commonPool-worker-33] ProgressLogger - 0.0% [INFO ] 2023-07-20 17:57:48.360 [ForkJoinPool.commonPool-worker-28] ProgressLogger - 0.01% [INFO ] 2023-07-20 17:57:53.374 [ForkJoinPool.commonPool-worker-17] ProgressLogger - 0.01% [INFO ] 2023-07-20 17:57:58.399 [ForkJoinPool.commonPool-worker-27] ProgressLogger - 0.01% [INFO ] 2023-07-20 17:58:03.414 [ForkJoinPool.commonPool-worker-10] ProgressLogger - 0.01% [INFO ] 2023-07-20 17:58:08.415 [ForkJoinPool.commonPool-worker-14] ProgressLogger - 0.01% [INFO ] 2023-07-20 17:58:13.423 [ForkJoinPool.commonPool-worker-14] ProgressLogger - 0.01% [INFO ] 2023-07-20 17:58:18.485 [ForkJoinPool.commonPool-worker-19] ProgressLogger - 0.01% [INFO ] 2023-07-20 17:58:23.500 [ForkJoinPool.commonPool-worker-29] ProgressLogger - 0.01% [INFO ] 2023-07-20 17:58:28.506 [ForkJoinPool.commonPool-worker-20] ProgressLogger - 0.02% [INFO ] 2023-07-20 17:58:33.530 [ForkJoinPool.commonPool-worker-24] ProgressLogger - 0.02% ``` Postgresql database: ``` baremaps=# select table_name, pg_size_pretty(pg_relation_size(quote_ident(table_name))), pg_relation_size(quote_ident(table_name)) from information_schema.tables where table_catalog = 'baremaps' and table_schema = 'public' and table_type = 'BASE TABLE' order by pg_relation_size desc; table_name | pg_size_pretty | pg_relation_size -----------------+----------------+------------------ osm_nodes | 76 MB | 80117760 osm_ways | 13 MB | 13524992 spatial_ref_sys | 6896 kB | 7061504 osm_relations | 1384 kB | 1417216 osm_headers | 8192 bytes | 8192 (5 rows) ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
