> but there are some things pg just isn't fast enough for [hash joins anyone]

If you've a separable benchmark for this, I'd be curious. I work on PG performance, including hashjoins, and real-world (-ish) benchmarks are good!