Re: Bulk Insert and Index use

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Bulk Insert and Index use
Дата
Msg-id m34qna76ow.fsf@wolfe.cbbrowne.com
обсуждение исходный текст
Ответ на Bulk Insert and Index use  (Rudi Starcevic <tech@wildcash.com>)
Ответы Re: Bulk Insert and Index use
Список pgsql-performance
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.

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

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.

But perhaps I'm misreading things; DDL for the intended tables and
indices would be real handy.
--
output = ("cbbrowne" "@" "cbbrowne.com")
http://www.ntlug.org/~cbbrowne/linux.html
Rules  of the  Evil  Overlord #21.  "I  will hire  a talented  fashion
designer  to create  original uniforms  for my  Legions of  Terror, as
opposed  to  some cheap  knock-offs  that  make  them look  like  Nazi
stormtroopers, Roman  footsoldiers, or savage Mongol  hordes. All were
eventually  defeated and  I want  my troops  to have  a  more positive
mind-set." <http://www.eviloverlord.com/>

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

Предыдущее
От: Rudi Starcevic
Дата:
Сообщение: Re: Bulk Insert and Index use
Следующее
От: "Gregory S. Williamson"
Дата:
Сообщение: Re: Bulk Insert and Index use