I've been using postgres since it was postgres95, not sure when that was really, but it's been a while. It has always been a wonderful DB. Sure there are a few things I'd like, but it's good enough to run half the state of Illinois circuit courts' data on for the last 8 years.
The 8.3 release allowed me to speed up some very difficult queries involving people searching on full_name=s% on the site where the search could run for 30-40 seconds, and this is on dedicated storage arrays. 8.3 allowed me to redcue the time to half a second or so. I couldn't have been more pleased.
I've always found tom lane to be extremely helpful with performace issues and what not. There's a great support community out there. It just a joy to use, and I know from my logs, that PG can handle 6 million+ queries and 1 million+ updates against a 300Gig DB every month on 4 thousand dollars worth of hardware.
These folks will never get enough praise as far as I'm concerned.