From: | Rudi Starcevic <tech(at)wildcash(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Bulk Insert and Index use |
Date: | 2004-08-11 04:10:52 |
Message-ID: | 41199C4C.9040308@wildcash.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
> In an attempt to throw the authorities off his trail, tech(at)wildcash(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Er Galvão Abbott | 2004-08-11 05:42:33 | NUMERIC x VARCHAR |
Previous Message | Gregory S. Williamson | 2004-08-11 03:53:11 | Re: Bulk Insert and Index use |