Re: Really bad insert performance: what did I do wrong? - Mailing list pgsql-performance

From Kevin White
Subject Re: Really bad insert performance: what did I do wrong?
Date
Msg-id 3E564A06.8070809@digital-ics.com
Whole thread Raw
In response to Really bad insert performance: what did I do wrong?  (Kevin White <kwhite@digital-ics.com>)
List pgsql-performance
 > Yipes.  We found awhile ago that Solaris' standard qsort() really sucks,
> but 7.3 should work around that --- and I don't think qsort would be
> invoked during data load anyway.
>
> Do you want to rebuild Postgres with profiling enabled, and get a gprof
> trace so we can see where the time is going?  You don't need to run it
> for two days --- a few minutes' worth of runtime should be plenty.

Great...I'd love to...as I've never had a problem with Postgres like
this, I didn't even know where to start...I'll look for how to do that.

Kevin



pgsql-performance by date:

Previous
From: Kevin White
Date:
Subject: Really bad insert performance: what did I do wrong?
Next
From: Tom Lane
Date:
Subject: Re: Really bad insert performance: what did I do wrong?