(I haven't followed the thread closely, but would like to comment anyway
;)
> >sold on unix and more importantly open-source, but this performance
> >problem sure isn't helping my little "campaign." ;-)
> um.. looks like Solaris is the issue here - If you can persuade your
> server management company to play ball, how about :
> 1/ Change Platform
> 2/ Change OS
That is a pretty drastic set of alternatives. Solaris can do just fine
as a PostgreSQL platform. Certainly 2GHz Intel hotboxes can spin more
cpu cycles than a 200MHz Solaris box (I don't know the specifics of your
hosting environment), and if you are just flat out asking for more than
the box can do then swapping hosts is an alternative. But unless you
have exhausted the possibilities for tuning on your existing box you
likely still have some things you can do to make the most of what you
have.
Good luck!
- Thomas