AW: [HACKERS] Well, then you keep your darn columns - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: [HACKERS] Well, then you keep your darn columns
Date
Msg-id 219F68D65015D011A8E000006F8590C603FDC222@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List 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


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Re: AW: AW: [HACKERS] Some notes on optimizer cost estimates
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] Well, then you keep your darn columns