The latest version of Postgres addresses this issue in various ways, although it’s not entirely solved, it should be significantly mitigated.