Scaling with PostgreSQL without boiling the ocean

  • How it started:

    > Scaling PostgreSQL successfully doesn’t always require a full team of DBAs and experts.

    How it's going:

    > Monitor TOAST table sizes and access patterns via pg_stat_sys_tables

    Don't get me wrong, this is a good article I wish I read three years ago, but this is 100% expert level stuff that glazes the eyes of the average CRUD dev.

  • hey hey! thanks for reading and posting to HN - (post author)

  • I mean, these are all useful techniques for scaling Postgres, but, like... they're also a list of why scaling Postgres is hard.