AW: [HACKERS] Well, then you keep your darn columns

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'pgsql-hackers(at)postgreSQL(dot)org'" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: AW: [HACKERS] Well, then you keep your darn columns
Date: 2000-01-26 09:23:43
Message-ID: 219F68D65015D011A8E000006F8590C603FDC222@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> >But the decision was (from Vadim IIRC) to drop them, at
> least in non system
> >tables.
> >The cited reasons were:
> >* crappy implementation that taxed performance (probably
> fixed by now)
> >* nobody else seemed to have them and the push then was to
> the direction of
> > mainstream bean-counting DB with main objective of getting
> that base
> > functionality right.
>
> Regarding this last, Oracle has an equivalent - rowid. In the web
> toolkit I'm helping port, it's used somewhat often, and having oid
> available has been a convenience.

rowid's are something completely different.
They do exist in Postgresql, and are called xtid.
(I suggested naming them rowid on the SQL level)
They have the advantage, that they don't need an index,
because they represent the physical location of the row.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2000-01-26 09:47:11 RE: [HACKERS] Well, then you keep your darn columns
Previous Message Zeugswetter Andreas SB 2000-01-26 09:15:29 Re: [HACKERS] Well, then you keep your darn columns (oid)