Thanks to input Bruce M., figured out my performance problems - had to do with a few QUERIES FROM HELL! After running EXPLAIN a few times I fine tuned some of the worst ones, mostly over use of sub queries. Still combing through my query log. Getting there... -r
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html