Re: Really bad insert performance: what did I do wrong?

From: "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Really bad insert performance: what did I do wrong?
Date: 2003-02-21 15:51:55
Message-ID: 200302212121.55483.shridhar_daithankar@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Oleg Lebedev 2003-02-21 16:30:53 slow query
Previous Message Kevin White 2003-02-21 15:47:18 Re: Really bad insert performance: what did I do wrong?