Re: Adding foreign key performance

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Adding foreign key performance
Дата
Msg-id 20031028101820.T64490@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: Adding foreign key performance  (Jeff <threshar@torgo.978.org>)
Ответы Re: Adding foreign key performance  (Jeff <threshar@torgo.978.org>)
Re: Adding foreign key performance  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-performance
On Tue, 28 Oct 2003, Jeff wrote:

> On Tue, 28 Oct 2003 09:16:45 -0500
> Jeff <threshar@torgo.978.org> wrote:
>
>
> > 7.3.4: 328912ms [cpu pegged]
> > 7.4b4: 298383ms [cpu pegged]
> >
>
> Just loaded up delicious 7.4b5 and wow...
>
> sort_mem 8192:  137038ms [lots of tmp file activity]
> sort_mem 256000: 83109ms

Hmm, 298383 -> 83109 (since those are the 256k numbers).  Not as
much as I'd have hoped, but I'll take a factor of 3.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "John K. Herreshoff"
Дата:
Сообщение: Re: Adding foreign key performance
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Adding foreign key performance