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

2019-03-03 Thread Tom Lane
Konstantin Knizhnik 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.

Index-only scan is slower than Index scan.

2018-11-23 Thread Konstantin Knizhnik
Hi hackers, One of our customers noticed strange thing: time of execution of the same query is about 25% slower with index only scan, comparing with indexscan plan (produced with enable_indexonlyscan = off). The query is the following: SELECT     T1._Period,     T1._RecorderTRef,     T1._Reco