Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com [216.136.173.32]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4UNBcE20841 for ; Wed, 30 May 2001 19:11:38 -0400 (EDT) (envelope-from chrup999@yahoo.com) Received: from chill-025.bbnow.net (HELO ?192.168.0.4?) (24.219.2.25) by smtp.mail.vip.sc5.yahoo.com with SMTP; 30 May 2001 23:11:34 -0000 X-Apparently-From: User-Agent: Microsoft-Entourage/9.0.1.3108 Date: Wed, 30 May 2001 18:11:26 -0500 Subject: Re: Unique record Identifier? From: Chris Ruprecht To: "pgsql-sql@postgresql.org" Message-ID: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Archive-Number: 200105/350 X-Sequence-Number: 3191 on 05/30/2001 16:33, Josh Berkus at josh@agliodbs.com wrote: > Chris, > Thanks Josh - that was my next step. At the moment, the database is not in production, I'm running a Progress database there, but I'm trying to learn the dos and don'ts in PG. I don't really need to backfill the records, I can just drop the table and re-create it (On my Mac PowerBook it loads 1.2 million records in about 5 minutes without any index on the table). I'm sure, I will have many more questions in the future ... Best regards, Chris _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com