I strongly urge all Drupal developers to read through this paper on Postgres. This is a 15 year old design document from PostgreSQL’s predecessor, but there are many gems in this which apply directly to where (I think) Drupal is headed. I intended to write this up properly as an informal presentation, but it came up on #drupal today, so thought I might as well share it with everyone.