Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010 - Mailing list pgsql-hackers

From Ana Carolina Brito de Almeida
Subject Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010
Date
Msg-id AANLkTinf4ZinGzDi_Y565G0JvzQUY-JkLTJdnrCL4wRW@mail.gmail.com
Whole thread
In response to Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010  (Jeroen Vermeulen <jtv@xs4all.nl>)
Responses Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010
List 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@xs4all.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

pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Extensions, this time with a patch
Next
From: Florian Weimer
Date:
Subject: Re: crash-safe visibility map, take three