Lutischán Ferenc wrote:
> It is possible to make an index on the table, and make a seq index scan
> on this values?
My understanding is that this isn't possible in PostgreSQL, because
indexes do not contain information about tuple visibility. Data read
from the index might refer to tuples that've been deleted as far as your
transaction is concerned, or to tuples that were created after your
snapshot was taken.
--
Craig Ringer