Sam Mason <sam@xxxxxxxxxxxxx> writes: > On Thu, Apr 16, 2009 at 11:29:25AM -0400, Tom Lane wrote: >> , a full table indexscan isn't going to be particularly fast in >> any case; it's often the case that seqscan-and-sort is the right >> decision. > Is PG capable of "skipping" over duplicate values using an index? No, not at present. It's on the TODO list. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general