Lists: | pgsql-hackers |
---|
From: | "hans wulf" <lotu1(at)gmx(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Will Index-only-scan be in 9.2 |
Date: | 2011-10-12 00:08:18 |
Message-ID: | 20111012000818.140360@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
I was wondering if the index-only-scan will be available in 9.2? This is not having to visit the real data to answer a query, if all the information is available in the index. I think this will be a mayor step in overtaking the big O in the g-spot.
There seams to already be some patch for this problem, but I don't know if you are considering this for the next release? Why is the enthusiasm so low on this feature? I would presume this is a mayor performance boost, not having to run through millons of stupid pages if all the info is already in the index.
--
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!
Jetzt informieren: http://www.gmx.net/de/go/freephone
From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
---|---|
To: | hans wulf <lotu1(at)gmx(dot)net> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Will Index-only-scan be in 9.2 |
Date: | 2011-10-14 06:57:13 |
Message-ID: | 1318575440.2086.4.camel@lenovo01-laptop03.gunduz.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Wed, 2011-10-12 at 02:08 +0200, hans wulf wrote:
> I was wondering if the index-only-scan will be available in 9.2? This
> is not having to visit the real data to answer a query, if all the
> information is available in the index. I think this will be a mayor
> step in overtaking the big O in the g-spot.
>
http://rhaas.blogspot.com/2011/10/index-only-scans-weve-got-em.html
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz