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

From: Kevin White <kwhite(at)digital-ics(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Really bad insert performance: what did I do wrong?
Date: 2003-02-21 15:47:18
Message-ID: 3E564A06.8070809@digital-ics.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar<shridhar_daithankar@persistent.co.in> 2003-02-21 15:51:55 Re: Really bad insert performance: what did I do wrong?
Previous Message Tom Lane 2003-02-21 15:45:03 Re: Really bad insert performance: what did I do wrong?