| From: | Ana Carolina Brito de Almeida <anacrl(at)ig(dot)com(dot)br> |
|---|---|
| To: | Jeroen Vermeulen <jtv(at)xs4all(dot)nl> |
| Cc: | Sergio Lifschitz <sergio(at)inf(dot)puc-rio(dot)br>, Richard Huxton <dev(at)archonet(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010 |
| Date: | 2010-12-03 13:49:32 |
| Message-ID: | AANLkTinf4ZinGzDi_Y565G0JvzQUY-JkLTJdnrCL4wRW@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Jeroen,
We add a simple case study (sourceforge page):
http://sourceforge.net/projects/hypotheticalind/files/TUTORIAL_8_4.pdf/download
Although this tutorial is for version 8.4, it also applies to other
versions.
Att,
Ana Carolina
2010/12/3 Jeroen Vermeulen <jtv(at)xs4all(dot)nl>
> On 2010-12-03 19:44, Sergio Lifschitz wrote:
>
>> Indeed, hypothetical indexes are good to check potentially good
>> configurations without harming the whole system with actual index
>> creation. Please observer that we've added an "explain hypothetical"
>> command, that will include plans considering hypothetical indexes! We'll
>> try to add a simple case study that would help those wondering about
>> this project.
>>
>
> That sounds very useful indeed!
>
>
> Jeroen
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-12-03 14:01:34 | Re: Extensions, this time with a patch |
| Previous Message | Jeroen Vermeulen | 2010-12-03 13:40:01 | Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010 |