Skip to content

Instantly share code, notes, and snippets.

@pnorman
Created June 25, 2013 08:36
Show Gist options
  • Save pnorman/5856935 to your computer and use it in GitHub Desktop.
Save pnorman/5856935 to your computer and use it in GitHub Desktop.
size of errol's osm2pgsql database
osm2pgsql=> \d+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+--------------------+-------+----------+------------+-------------
public | geography_columns | view | postgres | 0 bytes |
public | geometry_columns | view | postgres | 0 bytes |
public | planet_osm_line | table | apmon | 63 GB |
public | planet_osm_nodes | table | apmon | 8192 bytes |
public | planet_osm_point | table | apmon | 13 GB |
public | planet_osm_polygon | table | apmon | 56 GB |
public | planet_osm_rels | table | apmon | 1501 MB |
public | planet_osm_roads | table | apmon | 8501 MB |
public | planet_osm_ways | table | apmon | 90 GB |
public | raster_columns | view | postgres | 0 bytes |
public | raster_overviews | view | postgres | 0 bytes |
public | spatial_ref_sys | table | postgres | 3224 kB |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment