Ned,
I know myYearbook.com does something like 18,000 queries per second at peak
load times, which is for something like 12,000 users. They're using
pgBouncer, of course ... beyond about 1000 connections you *must* use a
connection pool our you're dead.
--
Josh Berkus
PostgreSQL @ Sun
San Francisco