Index access using multi-column indices

Started by Hiroshi Inoueover 26 years ago2 messages
#1Hiroshi Inoue
Inoue@tpf.co.jp
1 attachment(s)

Hello all,

Currently,only the first column of multi-column indices
is used to find start scan position of Indexscan-s.

To speed up finding scan start position,I have changed
_bt_first() to use as many keys as possible.

I'll attach the patch here.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp

Attachments:

multii.diff.gzapplication/x-gzip; name=multii.diff.gzDownload
#2Vadim Mikheev
vadim@krs.ru
In reply to: Hiroshi Inoue (#1)
Re: [HACKERS] Index access using multi-column indices

Hiroshi Inoue wrote:

Hello all,

Currently,only the first column of multi-column indices
is used to find start scan position of Indexscan-s.

To speed up finding scan start position,I have changed
_bt_first() to use as many keys as possible.

Nice!

Vadim