[Tile-serving] [osm2pgsql] Use FILLFACTOR 100 for non-updatable imports (#28)

pnorman notifications at github.com
Tue May 14 22:50:05 UTC 2013

When importing with ``--drop`` or without ``--slim`` the resulting tables will be static (i.e. not updated in the future).

The [``FILLFACTOR``](http://www.postgresql.org/docs/current/static/sql-createindex.html#SQL-CREATEINDEX-STORAGE-PARAMETERS) parameter allows the creation of physically smaller indices. For static tables fillfactor 100 is best to minimize the physical size. This results in more page splits on updates, but if the tables are never updated this is not an issue.

Using a fillfactor of 100 if ``--drop`` is specified or ``--slim`` is not specified would reduce index size, slightly speeding up the database.

fillfactor appears to be backwards compatible to postgres 8.2

Reply to this email directly or view it on GitHub:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20130514/71cae0c4/attachment.html>

More information about the Tile-serving mailing list