Horton

Re: Index-only scan is slower than Index scan.

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-03-03T21:58:17Z
Lists: pgsql-hackers 
Konstantin Knizhnik <k.knizhnik@postgrespro.ru> writes:
> I have replaced loop extracting attributes using index_getattr() in 
> StoreIndexTuple with invocation of index_deform_tuple()
> and reimplemented last one in the same way as heap_deform_tuple (extract 
> all attributes in one path).

Pushed with minor cosmetic fixes.

			regards, tom lane

Commits

  1. Improve performance of index-only scans with many index columns.