AW: Performance (was: The New Slashdot Setup (includes MySqlserver)) - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Performance (was: The New Slashdot Setup (includes MySqlserver))
Date
Msg-id 219F68D65015D011A8E000006F8590C604AF7D9A@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: Performance (was: The New Slashdot Setup (includes MySqlserver))  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> > > 3. automatic_rowid = no
> > > 
> > > The description simply says Automatic rowid. Does this apply to
> > > query result sets or to the underlying relation? If the latter,
> > > PostgreSQL has, of course, an OID for every tuple in the
> > > database.
> > > 
> > I'll have them fix that. MySQL calls them "_rowid" and 
> apparently tests
> > only for these.
> 
> Well, I don't see _rowid in the SQL spec either, so we are both
> non-standard here, though I believe our OID is SQL3.

Which is imho not what the test is for. I think they mean ctid,
which again I think we should have a rowid alias for (as in Informix,
Oracle).

Andreas


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: More Performance
Next
From: Hannu Krosing
Date:
Subject: Re: [GENERAL] Re: Postgresql OO Patch