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
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) |