From: | Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
Cc: | "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: AW: Performance (was: The New Slashdot Setup (includes MySqlserver)) |
Date: | 2000-05-26 06:30:41 |
Message-ID: | 00052608341002.00143@zeus |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 26 May 2000, Peter Eisentraut wrote:
> Zeugswetter Andreas SB writes:
>
> > 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).
>
> Let's step back and ask: How is the behaviour of rowid (or whatever)
> defined in various existing DBMS. Then we can see if we have anything that
> matches.
This has been discussed. The outcome is, that you are only safe using rowid
if nobody else changes the row inbetween you reading it and accessing it by rowid.
This is essentially the same in all db's only the risk of rowid changing is lower
in other db's since they do inplace update, but the risk is there nevertheless.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2000-05-26 06:43:08 | RE: Create user/create database outside template1 |
Previous Message | Andreas Zeugswetter | 2000-05-26 06:27:40 | Re: parser oddity (t.count) |