Re: Bulk Insert and Index use

Поиск
Список
Период
Сортировка
От Rudi Starcevic
Тема Re: Bulk Insert and Index use
Дата
Msg-id 41199C4C.9040308@wildcash.com
обсуждение исходный текст
Ответ на Re: Bulk Insert and Index use  (Christopher Browne <cbbrowne@acm.org>)
Список pgsql-performance
Hi,

> In an attempt to throw the authorities off his trail, tech@wildcash.com (Rudi Starcevic) transmitted:
> A minute for your thoughts and/or suggestions would be great.

Heh heh ....

> Could you give a more concrete example?  E.g. - the DDL for the
> table(s), most particularly.

Thanks, I didn't add the DDL as I though it may make my question too
long. I have the DDL at another office so I'll pick up this email
thread when I get there in a couple hours.

> At first guess, I think you're worrying about a nonissue.  Each insert
> will lead to a _modification_ of the various indices, which costs
> _something_, but which is WAY less expensive than creating each index
> from scratch.

Very interesting, modification and creation.
I will post another email later today.

Many thanks.

--

Regards,
Rudi.

Internet Media Productions

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

Предыдущее
От: "Gregory S. Williamson"
Дата:
Сообщение: Re: Bulk Insert and Index use
Следующее
От: Er Galvão Abbott
Дата:
Сообщение: NUMERIC x VARCHAR