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

Поиск
Список
Период
Сортировка
От Kevin White
Тема Re: Really bad insert performance: what did I do wrong?
Дата
Msg-id 3E564A06.8070809@digital-ics.com
обсуждение исходный текст
Ответ на Really bad insert performance: what did I do wrong?  (Kevin White <kwhite@digital-ics.com>)
Список 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 по дате отправления:

Предыдущее
От: Kevin White
Дата:
Сообщение: Really bad insert performance: what did I do wrong?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Really bad insert performance: what did I do wrong?