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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html