Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] OID & indexes. - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] OID & indexes.
Date
Msg-id 21907.937926630@sss.pgh.pa.us
Whole thread Raw
In response to OID & indexes.  (raptor <raptor@unacs.bg>)
List pgsql-sql
Tree view 
raptor <raptor@unacs.bg> writes:
> Is the OID fileld indexed and if not can I create index on it.

No, and yes.  OID is just like any regular column as far as
indexing is concerned.  You should make an index on it if you
plan to do lots of 'WHERE oid = something' queries.
        regards, tom lane

pgsql-sql by date:

Previous
From: Stuart Rison
Date:
Subject: Re: [SQL] Subselect performance
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] OID & indexes.