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