Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010

From: Jeroen Vermeulen <jtv(at)xs4all(dot)nl>
To: Sergio Lifschitz <sergio(at)inf(dot)puc-rio(dot)br>
Cc: Richard Huxton <dev(at)archonet(dot)com>, Ana Carolina Brito de Almeida <anacrl(at)ig(dot)com(dot)br>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010
Date: 2010-12-03 13:40:01
Message-ID: 4CF8F331.60408@xs4all.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ana Carolina Brito de Almeida 2010-12-03 13:49:32 Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010
Previous Message Andrew Dunstan 2010-12-03 13:02:11 Re: WIP patch for parallel pg_dump