Re: degrading inser performance

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: degrading inser performance
Дата
Msg-id CAJghg4KWkUhkzNeuqkihDCxVBgseJDeCoYni735RwiUOad4-5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: degrading inser performance  (Eildert Groeneveld <eildert.groeneveld@fli.bund.de>)
Ответы Re: degrading inser performance  (Eildert Groeneveld <eildert.groeneveld@fli.bund.de>)
Список pgsql-performance

On Thu, Sep 17, 2015 at 9:19 AM, Eildert Groeneveld <eildert.groeneveld@fli.bund.de> wrote:
>  * one COPY per bulk (20 000 rows)
copy does not fit so well, as it is not only initial populating.

Why do you say COPY doesn't fit? It seems to me that COPY fits perfectly for your case, and would certainly make the load faster.

I suspect (not sure though) that the degradation is most because you are inserting one row at a time, and, it needs to verify FSM (Free Space Map) for each tuple inserted, when the table start to get more populated, this verification starts to become slower. If that is really the case, COPY would certainly improve that, or even INSERT with many rows at once.

Regards,
--
Matheus de Oliveira


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

Предыдущее
От: Eildert Groeneveld
Дата:
Сообщение: Re: degrading inser performance
Следующее
От: Eildert Groeneveld
Дата:
Сообщение: Re: degrading inser performance