Re: Improve Seq scan performance - Mailing list pgsql-performance

From Craig Ringer
Subject Re: Improve Seq scan performance
Date
Msg-id 4917DAFB.8000003@postnewspapers.com.au
Whole thread Raw
In response to Improve Seq scan performance  (Lutischán Ferenc <lutischanf@gmail.com>)
Responses Re: Improve Seq scan performance
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Lutischán Ferenc
Date:
Subject: Improve Seq scan performance
Next
From: "Vladimir Sitnikov"
Date:
Subject: Re: Improve Seq scan performance