| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
| Cc: | Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Index scan optimization |
| Date: | 2014-11-16 14:00:02 |
| Message-ID: | CA+U5nML9xujCcg9Rq8z6dpXAszS7kR2_iJ0ZpzUkmz2X3LrBiA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 30 October 2014 08:43, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> wrote:
> I marked the patch as ready for committer.
This looks very interesting.
The value of the patch seems to come from skipping costly checks. Your
performance test has a leading VARCHAR column, so in that specific
case skipping the leading column is a big win. I don't see it would be
in all cases.
Can we see a few tests on similar things to check for other
opportunities and regressions.
* Single column bigint index
* Multi-column bigint index
* 5 column index with mixed text and integers
The explanatory comments need some work to more clearly explain what
this patch does.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2014-11-16 14:43:17 | Re: Order of views in stats docs |
| Previous Message | Maeldron T. | 2014-11-16 13:12:44 | Re: Failback to old master |