Denis Perchine <dyp@perchine.com> writes:
> I think this question already was raised here, but... Why PostgreSQL
> does not do this? What are the pros, and contros?
The reason you have to visit the main table is that tuple validity
status is only stored in the main table, not in each index. See prior
discussions in the archives.
regards, tom lane