Re: COPY with INDEXES question

Поиск
Список
Период
Сортировка
От Slavisa Garic
Тема Re: COPY with INDEXES question
Дата
Msg-id Pine.GSO.4.10.10402061351490.25207-100000@bruce.csse.monash.edu.au
обсуждение исходный текст
Ответ на Re: COPY with INDEXES question  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-performance
Thanks for the reply and thanks even more for the good one :).

Cheers,
Slavisa

On Fri, 6 Feb 2004, Christopher Kings-Lynne wrote:

> > 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: COPY with INDEXES question
Следующее
От: "Octavio Alvarez"
Дата:
Сообщение: Seq scan on zero-parameters function