Just thought i'd mention that on top of optimising postgres as much as
possible, don't forget how much something like memcached can do for you
http://www.danga.com/memcached/
we use it on www.last.fm - most pages only take one or two database hits,
compared with 30 to 40 when memcache is turned off.
Rich.