Re: COPY with INDEXES question

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: COPY with INDEXES question
Дата
Msg-id 402301D4.8030604@familyhealth.com.au
обсуждение исходный текст
Ответ на COPY with INDEXES question  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
Ответы Re: COPY with INDEXES question  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
Список pgsql-performance
> 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