searching oid's

From: admin <admin(at)wtbwts(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: searching oid's
Date: 2000-01-13 13:38:45
Message-ID: Pine.BSF.4.10.10001131327050.70888-100000@server.b0x.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've been contemplating the idea of replacing my current char(32)
identification numbers with oid's. Apart from the significant space
gained, I was hoping there would also be a speed gain or some other
incentives.

First, I tried searching tables by their oid, but explain returned
sequential scans. Second, I tried specifing the oid as the primary key in
a table, but the oid column wasn't found. Finally, I created an index for
oid which worked fine. In the end, I feel I'm back to square one having to
use the same index as with my char(32) id's. It seems my only gain would
be 28 bytes per row and no speed gain, apart perhaps for building the
index which should be a bit slower for a char(32) datatype rather than an
integer.

If there's something I'm missing, I'd appreciate if someone could share
their tips and tricks to using oid's more efficiently.

Thanks,
Marc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexey Vyskubov 2000-01-13 13:56:41 PostgreSQL external functions under OpenBSD
Previous Message Bruce Momjian 2000-01-13 13:06:37 Re: [GENERAL] Simulating an outer join