Re: Adding foreign key performance

Поиск
Список
Период
Сортировка
От Jeff
Тема Re: Adding foreign key performance
Дата
Msg-id 20031028133431.0bf17ce4.threshar@torgo.978.org
обсуждение исходный текст
Ответ на Re: Adding foreign key performance  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-performance
On Tue, 28 Oct 2003 10:32:36 -0800 (PST)
Stephan Szabo <sszabo@megazone.bigpanda.com> wrote:

> 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.

Yes. those are the numbers for 256MB of sort_mem.

It seemed to saturate the IO so once I get more disks in here it should
hopefully speed up.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

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

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