Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id LAA02695 for postgres-redist; Wed, 29 Jun 1994 11:22:38 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199406291822.LAA02695@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from eden.CS.Berkeley.EDU (eden.CS.Berkeley.EDU [128.32.149.4]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id LAA02685 for ; Wed, 29 Jun 1994 11:22:37 -0700 Received: from localhost (andrew@localhost) by eden.CS.Berkeley.EDU (8.6.4/8.1B) id LAA18721; Wed, 29 Jun 1994 11:22:33 -0700 Date: Wed, 29 Jun 1994 11:22:33 -0700 From: "Andrew K. Yu" Message-Id: <199406291822.LAA18721@eden.CS.Berkeley.EDU> To: joerg.plewe@mpi-dortmund.mpg.de Subject: Re: Access via OID Cc: postgres@postgres.Berkeley.EDU Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Wed, 29 Jun 94 11:22:38 -0700 Resent-XMts: smtp > I think no, but e.g. for Oracle I know that having a rowid > lets you access the tuple VERY fast, because file,block,... > are encoded in the rowid, so Oracle does not have to search. > Is there a similar mechanism for Postgres? The oid in postgres has no encoding at all. -andrew ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU" If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ==============================================================================