Re: Performance die when COPYing to table with bigint PK

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Performance die when COPYing to table with bigint PK
Дата
Msg-id 4E3A8F07020000250003FA72@gw.wicourts.gov
обсуждение исходный текст
Ответ на Performance die when COPYing to table with bigint PK  (Robert Ayrapetyan <robert.ayrapetyan@comodo.com>)
Ответы Re: Performance die when COPYing to table with bigint PK  (Robert Ayrapetyan <robert.ayrapetyan@comodo.com>)
Список pgsql-performance
Robert Ayrapetyan <robert.ayrapetyan@comodo.com> wrote:

> If you look at the rest of my mail - you would notice 50 times
> difference in performance.
> What you would say?

That accessing a page from RAM is more than 50 times as fast as a
random access of that page from disk.

-Kevin

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Need to tune for Heavy Write
Следующее
От: Samuel Gendler
Дата:
Сообщение: Re: Need to tune for Heavy Write