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.
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" ... |