X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6A64FD1B50C; Tue, 27 Apr 2004 18:43:38 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 36987-10; Tue, 27 Apr 2004 18:43:38 -0300 (ADT) Received: from FE-mail04.sfg.albacom.net (FE-mail04.albacom.net [213.217.149.84]) by svr1.postgresql.org (Postfix) with ESMTP id 641CFD1B4F6; Tue, 27 Apr 2004 18:43:35 -0300 (ADT) Received: from axa.it (217.221.80.72) by FE-mail04.sfg.albacom.net (7.0.009) id 408E270C00015408; Tue, 27 Apr 2004 23:42:57 +0200 Message-ID: <408ED3E2.802@axa.it> Date: Tue, 27 Apr 2004 23:42:58 +0200 From: Edoardo Ceccarelli User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: it, en, en-us MIME-Version: 1.0 To: pg@fastcrypt.com Cc: Christopher Kings-Lynne , "pgsql-jdbc@postgresql.org" , pgsql-performance@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [JDBC] [PERFORM] is a good practice to create an index on the References: <408D3AE8.5020006@axa.it> <408DC9E1.8020704@familyhealth.com.au> <1083067187.14759.178.camel@localhost.localdomain> <408E75C2.5060703@familyhealth.com.au> <1083079114.14759.204.camel@localhost.localdomain> In-Reply-To: <1083079114.14759.204.camel@localhost.localdomain> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=3.0 tagged_above=0.0 required=5.0 tests=SUSPICIOUS_RECIPS X-Spam-Level: *** X-Archive-Number: 200404/327 X-Sequence-Number: 13300 I am going to use them as primary key of the table, so I'll surely need them unique :) thank you for you help Edoardo Dave Cramer ha scritto: >Edoardo, > >Are you using them for referential integrity? If so you would be wise to >use sequences instead. > >Christopher: yes you are correct, I wasn't sure if that is what he was >doing. > >Dave >On Tue, 2004-04-27 at 11:01, Christopher Kings-Lynne wrote: > > >>>AFAIK, oids aren't used for anything internally, so duplicates don't >>>really matter. Besides, what would you do about duplicate oid's ? >>> >>> >>If he's using them _externally_, then he does have to worry about >>duplicates. >> >>Chris >> >> >> >>!DSPAM:408e75e0137721921318500! >> >> >> >>