On Friday 21 Feb 2003 9:02 pm, you wrote:
> Any thoughts? I know that postgres should be more than capable of
> loading this data quickly on this box...I figured it could possibly take
> twice as long...and I thought my problem would be i/o related, not CPU.
First, check vmstat or similar on SunOS. See what is maxing out. Second tunr
postgresql trace on and see where it is specnding most of the CPU.
Needless to say, did you tune shared buffers?
Shridhar