Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Cramer
Subject Re: [PERFORM] is a good practice to create an index on the
Date
Msg-id 1083079114.14759.204.camel@localhost.localdomain
Whole thread Raw
In response to Re: [PERFORM] is a good practice to create an index on the  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: [PERFORM] is a good practice to create an index on the
List pgsql-jdbc
Tree view 
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!
>
>
--
Dave Cramer
519 939 0336
ICQ # 14675561

pgsql-jdbc by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [PERFORM] is a good practice to create an index on the
Next
From: Dave Cramer
Date:
Subject: setCatalog