fpurcell
commented
4 months ago That processing time is not what I'd expect, Matt.
On my MacBook, I was able to load NJT's bus gtfs (took under 20 minutes):
- git clone https://github.com/OpenTransitTools/gtfsdb.git
- cd gtfsdb; buildout; buildout install postgresql
- wget https://transitfeeds.com/p/nj-transit/409/latest/download -O NJT.gtfs.zip
- psql -c "CREATE DATABASE njt WITH OWNER postgres";
- psql njt -c "CREATE EXTENSION postgis";
- bin/gtfsdb-load -s njt -d postgresql://postgres@localhost:5432/njt -g NJT.gtfs.zip
- psql -d njt -c "select st_asgeojson(geom) from njt.routes limit 1" -o njt_route.json
I'm currently building a database from the NJ Transit bus GTFS files. The data is about 200MB uncompressed. It's taking 3+ days to build the database. Is that expected? Or do you think this could be an issue with my Postgres host?
I've searched around the repo's discussions to see if expected processing times is mentioned anywhere and haven't had any luck.