I've a very huge table whose 1st column is a numeric value, starting from 0 at the 1st row and incremented by 1 each new row I inserted.
No holes, no duplicates.
I need to perform some very fast query based on this value, mainly around the last inserted rows. What is the best I can do? A normal index or is there a way to instruct the system to take advantage from that strong order? In theory, the number of the row is the only info the system would need to directly access that row.
So I'd like to avoid useless complex indexes if possible.


Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:

Reply via email to