> 2. If you've got lots of equal keys, it's conceivable that having the > index entries sorted by TID offers some advantage in indexscan speed. > I'm dubious that that's useful, mainly because the planner should prefer > a bitmap scan in such a case; and anyway the ordering is unlikely to > be preserved for long. But it's something to think about.
How about always adding the TID as last key when using qsort for create index ? Andreas -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
