Alex Pilosov writes:
> Explain shows it is using index scan, however, it looks like database is
> fetching blocks from all over the disk, when all information necessary is
> already in index.
All except the all-important piece of information whether the tuple is
visible to the current transaction. That you need to fetch from the main
table.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter