[OSM-dev] Nominatim Index bloat? Try pgindexrebuild, a production friendly index debloater
penorman at mac.com
Fri Aug 19 14:11:15 UTC 2016
On 8/19/2016 4:30 AM, Rory McCann wrote:
> Although I'm using this often, I'm always open to suggestions about
> braindead things I might be doing. ☺ Suggestions welcome!
It's good to see commands for a concurrent reindex scripted.
For rendering tables I'd recommend pausing updates, creating a new
ordered table, building indexes on the new table, then putting the new
table in place. The reclustering adds performance beyond what a reindex
For slim tables, I'd probably just pause updates and REINDEX.
http://reorg.github.io/pg_repack/ would be interesting on the slim
tables but can't operate on the rendering tables.
More information about the dev