There are some osm2psql developers and users who have written up howtos or blog posts, gave talks, filmed tutorials etc. Not all of that is up to date with current version of the software and recommended usage, but there is a lot to learn there.
See also the osm2pgsql page on the OSM wiki.
- Jochen Topf writes occasionally about osm2pgsql in his blog.
- Ryan Lambert of RustProof Labs has a blog with lots of osm2pgsql content.
- From SotM 2021: “News from osm2pgsql” by Jochen Topf. Slides, Download Video, Video on Youtube (July 2021).
- From FOSSGIS 2021: “Neues von osm2pgsql” by Jochen Topf (in German). Slides, Download Video, Video on Youtube (June 2021).
- From SotM 2019: “OSM data processing with PostgreSQL/PostGIS” by Jochen Topf. Slides, Download Video, Video on Youtube (September 2019).
- From SotM-US 2014: “osm2pgsql:mapnik — Optimizing the Rendering Toolchain” by Paul Norman. Video on Youtube.