[OSM-dev] Nominatim Index bloat? Try pgindexrebuild, a production friendly index debloater

Paul Norman 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 
http://paulnorman.ca/blog/2016/06/improving-speed-with-reclustering/ has 
example SQL.

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 mailing list