Postgres Pro
Downloads
Home   >   mailing lists

is a good practice to create an index on the oid? - Mailing list pgsql-admin

From Edoardo Ceccarelli
Subject is a good practice to create an index on the oid?
Date
Msg-id 408D3AE8.5020006@axa.it
Whole thread Raw
Responses Re: [JDBC] is a good practice to create an index on the oid?  (Dave Cramer <pg@fastcrypt.com>)
Re: [PERFORM] is a good practice to create an index on the oid?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-admin
Tree view 
I am using the oid of the table as the main key and I've found that is
not indexed (maybe because I have declared another primary key in the table)

it is a good practice to create an index like this on the oid of a table?
CREATE INDEX idoid annuncio400 USING btree (oid);


does it work as a normal index?

Thank you
Edoardo

pgsql-admin by date:

Previous
From: JC Jan Christensen
Date:
Subject: INITDB-error - end-of-copy marker error
Next
From: Dave Cramer
Date:
Subject: Re: [JDBC] is a good practice to create an index on the oid?