pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Bulk Insert and Index use
Date: Tue, 10 Aug 2004 22:24:31 -0400
Message-ID: <m34qna76ow.fsf@wolfe.cbbrowne.com> (raw)
References: <41195462.9090303@wildcash.com>

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/;



view thread (7+ messages)  latest in thread

Message-ID: <m34qna76ow.fsf@wolfe.cbbrowne.com>
Permalink:  ../m34qna76ow.fsf@wolfe.cbbrowne.com/
Also on:    postgresql.org/message-id/m34qna76ow.fsf@wolfe.cbbrowne.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: cbbrowne@acm.org
  Subject: Re: Bulk Insert and Index use
  In-Reply-To: <m34qna76ow.fsf@wolfe.cbbrowne.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox