Pressflow makes Drupal scale - hmm, a fork of Drupal with a special focus on scalability. Unfortunately, there is a restriction to MySQL - I would have preferred PostgreSQL. But the approach of building a fork with a special focus on scalability is commendable. Although Drupal itself could also achieve this (and aims to do so from version 7 onwards).