Hacker News new | ask | show | jobs
by yardstick 3030 days ago
Were the tables under your control? Could you set a low fill factor [1] for frequently updated tables (eg 30 or lower)? That would help avoid creating too many db pages.

[1] https://www.postgresql.org/docs/10/static/sql-createtable.ht...