Postgres Pro
Downloads
Home   >   mailing lists

Re: [JDBC] [PERFORM] is a good practice to create an index on the - Mailing list pgsql-admin

From Edoardo Ceccarelli
Subject Re: [JDBC] [PERFORM] is a good practice to create an index on the
Date
Msg-id 408ED3E2.802@axa.it
Whole thread Raw
In response to Re: [JDBC] [PERFORM] is a good practice to create an index on the  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: [JDBC] [PERFORM] is a good practice to create an index on the
List pgsql-admin
Tree view 
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!
>>
>>
>>
>>

pgsql-admin by date:

Previous
From: "Eduardo Naschenweng"
Date:
Subject: Optimizer choosing smaller index instead of right one
Next
From: jseymour@LinxNet.com (Jim Seymour)
Date:
Subject: Re: Recover data