Re: Improve COPY performance for large data sets

Поиск
Список
Период
Сортировка
От Scott Carey
Тема Re: Improve COPY performance for large data sets
Дата
Msg-id a1ec7d000809101051r75f451b4yef92396965453381@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Improve COPY performance for large data sets  ("Scott Carey" <scott@richrelevance.com>)
Список pgsql-performance
Correction --
 2 hours to read the whole disk.

1. It won't make a load take 12 hours unless we're talking a load that is in total, similar to the size of the disk.  A slow, newer SATA drive will read and write at at ~50MB/sec at minimum, so the whole 320GB can be scanned at 3GB per minute.  Thats ~ 5 hours.  It is not likely that 20M records is over 20GB, and at that size there is no way the disk is the bottleneck.

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

Предыдущее
От: "Scott Carey"
Дата:
Сообщение: Re: Improve COPY performance for large data sets
Следующее
От: "Scott Carey"
Дата:
Сообщение: Re: too many clog files