Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 6AD282E0046
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Wed, 28 May 2008 13:13:58 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 73135-05
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Wed, 28 May 2008 13:13:39 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.159])
	by developer.postgresql.org (Postfix) with ESMTP id 846EB2E0033
	for <pgsql-performance@postgresql.org>;
	Wed, 28 May 2008 13:13:39 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so1933127fgg.23
	for <pgsql-performance@postgresql.org>;
	Wed, 28 May 2008 09:13:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	bh=uhJpHkCcYS0nDzJ0kPIj4/sZI34WOSDAYz6OCf1A2+A=;
	b=hrgSMNGnMSEJSMCRoQlHasFWh261pUR7bzLNbmXIq31eiqOCycB4RBBZvfQ92nOrKOvCXdI6a3S9k2E/BXR8dS+gLBs+j77RyyPuw96AG71X5xMDQ7KfSUejzYIYgpMC0X+ZF5H1c1qiEC1iSsA9Lbr6qCocI1Daaf3q1XjiSEo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:references:x-google-sender-auth;
	b=T+tNyGuuOzZnCZXeF5Ps/NheulDaC8mTnhYxQEEZzT4BEH3gqed18YKbDV9fEFJ2aIRLBDu9gk98d5lhKZkQpYd4G5rsq1BNHdXkJzYXLKPKpTy8C/RMdBD+n6bbID5p7NJ2xOsaa31o4IT+xhD9HuYQhdeD5uND2jFaR9S9Xqg=
Received: by 10.86.77.5 with SMTP id z5mr79799fga.13.1211991218106;
	Wed, 28 May 2008 09:13:38 -0700 (PDT)
Received: by 10.86.36.10 with HTTP; Wed, 28 May 2008 09:13:38 -0700 (PDT)
Message-ID: <461a87490805280913ha5bbc90w63db53787ced2adf@mail.gmail.com>
Date: Wed, 28 May 2008 13:13:38 -0300
From: "Tarcizio Bini" <tarcizioab@c3sl.ufpr.br>
To: pgsql-performance@postgresql.org
Subject: Re: GEQO Benchmark
In-Reply-To: <27530.1211983350@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_12799_28137229.1211991218131"
References: <55311.200.17.202.126.1211982648.squirrel@webmail.inf.ufpr.br>
	<27530.1211983350@sss.pgh.pa.us>
X-Google-Sender-Auth: a2f625b075939414
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200805/355
X-Sequence-Number: 30323

------=_Part_12799_28137229.1211991218131
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@sss.pgh.pa.us>:

> tarcizioab@c3sl.ufpr.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
>

------=_Part_12799_28137229.1211991218131
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,<br><br>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.<br>
<br>--<br><br>Tarcizio Bini<br><br><div class="gmail_quote">2008/5/28 Tom Lane &lt;<a href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt;:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d"><a href="mailto:tarcizioab@c3sl.ufpr.br">tarcizioab@c3sl.ufpr.br</a> writes:<br>
&gt; I&#39;m using the TPC-H Benchmark for testing of performance in PostgreSQL.<br>
&gt; But it is composed of only 8 tables, which is not enough to call the GEQO<br>
&gt; algorithm.<br>
<br>
</div>See<br>
<a href="http://www.postgresql.org/docs/8.3/static/runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO" target="_blank">http://www.postgresql.org/docs/8.3/static/runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO</a><br>

<br>
particularly geqo_threshold.<br>
<br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;regards, tom lane<br>
</blockquote></div><br>

------=_Part_12799_28137229.1211991218131--