Skip site navigation (1) Skip section navigation (2)

Re: GEQO Benchmark

From: "Tarcizio Bini" <tarcizioab(at)c3sl(dot)ufpr(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: GEQO Benchmark
Date: 2008-05-28 16:13:38
Message-ID: 461a87490805280913ha5bbc90w63db53787ced2adf@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi,

Of course, the geqo_threshold can be changed so that the geqo be performed
in queries that have less than 12 tables. However, we aim to test the GEQO
algorithm in conditions where the standard algorithm (dynamic programming)
has a high cost to calculate the query plan.

--

Tarcizio Bini

2008/5/28 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> tarcizioab(at)c3sl(dot)ufpr(dot)br writes:
> > I'm using the TPC-H Benchmark for testing of performance in PostgreSQL.
> > But it is composed of only 8 tables, which is not enough to call the GEQO
> > algorithm.
>
> See
>
> http://www.postgresql.org/docs/8.3/static/runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO
>
> particularly geqo_threshold.
>
>                        regards, tom lane
>

In response to

Responses

pgsql-performance by date

Next:From: Simon RiggsDate: 2008-05-28 16:52:40
Subject: Re: GEQO Benchmark
Previous:From: Tom LaneDate: 2008-05-28 14:02:30
Subject: Re: GEQO Benchmark

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group