pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Indexes on OIDs ?
2+ messages / 2 participants
[nested] [flat]

* Indexes on OIDs ?
@ 1999-01-14 09:24  Dirk Lutzebaeck <lutzeb@aeccom.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Dirk Lutzebaeck @ 1999-01-14 09:24 UTC (permalink / raw)
  To: pgsql-sql


Hi,

is it meaningful to create indexes on OIDs when doing joins with them?

Dirk



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] Indexes on OIDs ?
@ 1999-01-14 14:55  Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 1999-01-14 14:55 UTC (permalink / raw)
  To: lutzeb@aeccom.com; +Cc: pgsql-sql

> 
> Hi,
> 
> is it meaningful to create indexes on OIDs when doing joins with them?
> 

Yes, absolutely.  They are not indexed by default.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-01-14 14:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-14 09:24 Indexes on OIDs ? Dirk Lutzebaeck <lutzeb@aeccom.com>
1999-01-14 14:55 Re: [SQL] Indexes on OIDs ? Bruce Momjian <maillist@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox