I imagine you want NUMA aware software specifically designed for multi-socket systems; off the top of my head the ones I've heard of are IBM DB2, SAP HANA, and Microsoft SQL Server — although I've had a chance to actually use any of them.
There was a study done recently that no major DBMS product can scale past 64 cores for similar reasons that Postgres can't -- too much contention on shared resources like locks.
