On Thu, Feb 18, 2010 at 11:08 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> Oracle and postgres are definitely different here. There's really no
> equivalent to rowid in pgsql. oid has no special optimizations. An
> indexed PK of a serial is about as good as it gets, possibly
> clustered.
access by CTID is the fastest it gets. I use it to do mass updates
after selecting a large number of rows. I can guarantee nobody else
is modifying those rows so i know it is safe.