Re: COPY with INDEXES question

Поиск
Список
Период
Сортировка
Искать
От
Christopher Kings-Lynne
Тема
Re: COPY with INDEXES question
Дата
Msg-id
402301D4.8030604@familyhealth.com.au
Ответ на
Список
Дерево обсуждения
Re: COPY with INDEXES question Rod Taylor <rbt@rbt.ca>
> I have a quick question. In order to speed up insertion of large number of
> rows (100s of thousands) I replaced the INSERT with the COPY. This works
> fine but one question popped into my mind. Does copy updates indexes on
> that table if there are some defined?

Yes, of course.  Runs triggers and stuff as well.

Chris

В списке pgsql-performance по дате отправления
От: Slavisa Garic
Дата:
Сообщение: COPY with INDEXES question
От: Slavisa Garic
Дата:
Сообщение: Re: COPY with INDEXES question
FAQ