Lists: | pgsql-hackers |
---|
From: | Ana Carolina Brito de Almeida <anacrl(at)ig(dot)com(dot)br> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | sergio(at)inf(dot)puc-rio(dot)br |
Subject: | Hypothetical Indexes - PostgreSQL extension - PGCON 2010 |
Date: | 2010-12-01 17:48:40 |
Message-ID: | AANLkTikHOL1LWoEGe3i5+hr0n60xt-Fh3Gwj71MjH_oZ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hackers,
We would like to inform you all that our extension to PostgreSQL, that
includes hypothetical indexes (and soon index self-tuning), is
available through a sourgeforge project.
This was suggested at PgCon 2010 and we hope some of you may find it
useful, contribute and give us your feedback.
Link to project:
http://sourceforge.net/projects/hypotheticalind/
Thanks,
Sergio Lifschitz
Ana Carolina Almeida
From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Ana Carolina Brito de Almeida <anacrl(at)ig(dot)com(dot)br> |
Cc: | pgsql-hackers(at)postgresql(dot)org, sergio(at)inf(dot)puc-rio(dot)br |
Subject: | Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010 |
Date: | 2010-12-01 18:01:20 |
Message-ID: | 4CF68D70.2050004@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Ana,
> We would like to inform you all that our extension to PostgreSQL, that includes hypothetical indexes (and soon index self-tuning), is available through a sourgeforge project.
> This was suggested at PgCon 2010 and we hope some of you may find it useful, contribute and give us your feedback.
Great to see this being available finally!
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
From: | Jeroen Vermeulen <jtv(at)xs4all(dot)nl> |
---|---|
To: | Ana Carolina Brito de Almeida <anacrl(at)ig(dot)com(dot)br> |
Cc: | pgsql-hackers(at)postgresql(dot)org, sergio(at)inf(dot)puc-rio(dot)br |
Subject: | Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010 |
Date: | 2010-12-03 08:14:26 |
Message-ID: | 4CF8A6E2.7040606@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 2010-12-02 00:48, Ana Carolina Brito de Almeida wrote:
> We would like to inform you all that our extension to PostgreSQL, that includes hypothetical indexes (and soon index self-tuning), is available through a sourgeforge project.
> This was suggested at PgCon 2010 and we hope some of you may find it useful, contribute and give us your feedback.
Looking at the sourceforge page, I'm left with one burning question:
what are they for?
I can see what a hypothetical index is, but neither the project pages
nor the README in the tarball say why I might want one. I'd be quite
interested to know that.
Jeroen
From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Jeroen Vermeulen <jtv(at)xs4all(dot)nl> |
Cc: | Ana Carolina Brito de Almeida <anacrl(at)ig(dot)com(dot)br>, pgsql-hackers(at)postgresql(dot)org, sergio(at)inf(dot)puc-rio(dot)br |
Subject: | Re: Hypothetical Indexes - PostgreSQL extension - PGCON 2010 |
Date: | 2010-12-03 10:06:08 |
Message-ID: | 4CF8C110.1080104@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 03/12/10 08:14, Jeroen Vermeulen wrote:
> On 2010-12-02 00:48, Ana Carolina Brito de Almeida wrote:
>
>> We would like to inform you all that our extension to PostgreSQL, that
>> includes hypothetical indexes (and soon index self-tuning), is
>> available through a sourgeforge project.
> Looking at the sourceforge page, I'm left with one burning question:
> what are they for?
I believe they're for performance testing. Add hypothetical index (takes
very little time). Check estimated costs with EXPLAIN. If good, add real
index (takes lots of time).
Of course, they're also good for indexing hypothetical data ;-)
--
Richard Huxton
Archonet Ltd
From: | Sergio Lifschitz <sergio(at)inf(dot)puc-rio(dot)br> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | Jeroen Vermeulen <jtv(at)xs4all(dot)nl>, 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 12:44:36 |
Message-ID: | 4CF8E634.9040705@inf.puc-rio.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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.
Sergio
On 3/12/2010 08:06, Richard Huxton wrote:
> On 03/12/10 08:14, Jeroen Vermeulen wrote:
>> On 2010-12-02 00:48, Ana Carolina Brito de Almeida wrote:
>>
>>> We would like to inform you all that our extension to PostgreSQL, that
>>> includes hypothetical indexes (and soon index self-tuning), is
>>> available through a sourgeforge project.
>
>> Looking at the sourceforge page, I'm left with one burning question:
>> what are they for?
>
> I believe they're for performance testing. Add hypothetical index
> (takes very little time). Check estimated costs with EXPLAIN. If good,
> add real index (takes lots of time).
>
> Of course, they're also good for indexing hypothetical data ;-)
>
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 |
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
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: | Raw Message | Whole Thread | Download mbox | Resend email |
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: | Jeroen Vermeulen <jtv(at)xs4all(dot)nl> |
---|---|
To: | Ana Carolina Brito de Almeida <anacrl(at)ig(dot)com(dot)br> |
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-04 10:38:00 |
Message-ID: | 4CFA1A08.2040209@xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 2010-12-03 20:49, Ana Carolina Brito de Almeida wrote:
> We add a simple case study (sourceforge page):
> http://sourceforge.net/projects/hypotheticalind/files/TUTORIAL_8_4.pdf/download
Great, thanks!
I'll try to write a bit more about it later:
http://pqxx.org/development/libpqxx/wiki/HypotheticalIndexes
Jeroen