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