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/Hypoth
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 cas
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
> On 2010-12-03 19:44, Sergio Lifsc
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 hypothet
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 s
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
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
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.
Hello Josh,
I will take a look at pgFoundry and register a new project for index
selection. I will also look for other projects there that we may help
somehow. About the tutorial, I will send you the presentation we used
to generate the web pages so that you can see it with OpenOffice. ;)
Th
On 10/12/2004 4:02 PM Tom Lane could be overheard saying::
Marcos A Vaz Salles <[EMAIL PROTECTED]> writes:
In order to make index selection possible, we
have extended the PostgreSQL DBMS to allow the simulation of
hypothetical indexes. We believe these server extensions may be of
value for addit
Tom,
>
> This would be of some value if the optimizer's cost estimates were
> highly reliable, but unfortunately they are far from being so :-(
> Without the ability to measure *actual* as opposed to estimated
> costs, I'm not sure you can really do much.
>
In fact, any index selection tool
Marcos,
> Â http://www.inf.puc-rio.br/~postgresql/
>
> Â There you will find a link to a tutorial based description of the
> hypothetical indexes feature we have implemented on PostgreSQL 7.4
> beta 3.
I would love to see this as an add-in project on pgFoundry. Particularly
since your online "
Marcos A Vaz Salles <[EMAIL PROTECTED]> writes:
> In order to make index selection possible, we
> have extended the PostgreSQL DBMS to allow the simulation of
> hypothetical indexes. We believe these server extensions may be of
> value for addition to the PostgreSQL code base.
This would be of som
Sent: Wednesday, October 06, 2004 7:40 PM
> To: [EMAIL PROTECTED]
> Cc: Sergio Lifschitz; Maira Ferreira de Noronha; [EMAIL PROTECTED]
> Subject: [HACKERS] Hypothetical Indexes
>
>
> Hello,
>
> I have just finished my M.Sc. thesis at Pontifícia
> Universidade Católica do R
Hello,
I have just finished my M.Sc. thesis at Pontifícia Universidade
Católica do Rio de Janeiro (PUC-Rio), Brazil, and we have developed a
research prototype for automatic index selection using a software
agent in PostgreSQL. In order to make index selection possible, we
have extended the Post
15 matches
Mail list logo
