pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rudi Starcevic <tech@wildcash.com>
To: pgsql-performance@postgresql.org
Subject: Re: Bulk Insert and Index use
Date: Wed, 11 Aug 2004 14:10:52 +1000
Message-ID: <41199C4C.9040308@wildcash.com> (raw)
In-Reply-To: <m34qna76ow.fsf@wolfe.cbbrowne.com>
References: <41195462.9090303@wildcash.com>
	<m34qna76ow.fsf@wolfe.cbbrowne.com>

Hi,

> 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.

Heh heh ....

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

Thanks, I didn't add the DDL as I though it may make my question too
long. I have the DDL at another office so I'll pick up this email
thread when I get there in a couple hours.

> 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.

Very interesting, modification and creation.
I will post another email later today.

Many thanks.

-- 

Regards,
Rudi.

Internet Media Productions



view thread (7+ messages)

Message-ID: <41199C4C.9040308@wildcash.com>
Permalink:  ../41199C4C.9040308@wildcash.com/
Also on:    postgresql.org/message-id/41199C4C.9040308@wildcash.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: tech@wildcash.com
  Subject: Re: Bulk Insert and Index use
  In-Reply-To: <41199C4C.9040308@wildcash.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