Re: Bulk Insert and Index use - Mailing list pgsql-performance

From Christopher Browne
Subject Re: Bulk Insert and Index use
Date
Msg-id m34qna76ow.fsf@wolfe.cbbrowne.com
Whole thread Raw
In response to Bulk Insert and Index use  (Rudi Starcevic <tech@wildcash.com>)
Responses Re: Bulk Insert and Index use
List 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 by date:

Previous
From: Rudi Starcevic
Date:
Subject: Re: Bulk Insert and Index use
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: Bulk Insert and Index use