Fast reference without an index?

From: pgsql(at)mohawksoft(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: Fast reference without an index?
Date: 2005-02-08 20:04:52
Message-ID: 16678.24.91.171.78.1107893092.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

A question to the hackers:

Is there a way, and if I'm being stupid please tell me, to use something
like a row ID to reference a row in a PostgreSQL database? Allowing the
database to find a specific row without using an index?

I mean, an index has to return something like a row ID for the database to
find the row, right? Granted it has to find the version with the right
transaction ID, but still, you get the idea. In the old days of ISAM
stuff, it would just be the offset into the file.

In my text search system, rather than create an additional indexed column
for row ID, wouldn't it be more efficient if I could use PostgreSQL's
data for this? This would greatly improve the performance of FTSS as it
would eliminate the extra index operation per row returned.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2005-02-08 20:18:37 Re: correlation in pg_stats
Previous Message pgsql 2005-02-08 19:46:42 Re: "external indices" ...