Postgres Pro
Downloads
Home   >   mailing lists

Index-only scans for GIST - Mailing list pgsql-hackers

From Anastasia Lubennikova
Subject Index-only scans for GIST
Date
Msg-id CAP4vRV55D9+Ou_TSnEDrD-TURMiPGT4AbFh_m5dZDkBSb07hkw@mail.gmail.com
Whole thread Raw
Responses Re: Index-only scans for GIST  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view
Hi, hackers!
There are first results of my work on GSoC project "Index-only scans for GIST".

1. Version of my project code is in forked repository
Patch is in attachments
- This version is only for one-column indexes
- fetch() method is realized only for box opclass (because it's trivial)

2. I test Index-only scans with SQL script box_test.sql 
and it works really faster. (results in box_test_out)

I'll be glad to get your feedback about this feature.

-- 

Best regards,
Lubennikova Anastasia
Attachment

pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Priority table or Cache table
Next
From: Thomas Mayer
Date:
Subject: Re: Window function optimisation, allow pushdowns of items matching PARTITION BY clauses