Re: -HEAD planner issue wrt hash_joins on dbt3 ?

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: Matteo Beccati <php(at)beccati(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: -HEAD planner issue wrt hash_joins on dbt3 ?
Date: 2006-09-28 16:16:09
Message-ID: 451BF549.3010607@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Matteo Beccati wrote:
> Stefan Kaltenbrunner wrote:
>> too bad - however any idea on one of the other troubling querys (q21) I
>> mentioned in the mail I resent to the list (after the original one got
>> lost)?
>>
>> http://archives.postgresql.org/pgsql-hackers/2006-09/msg02011.php
>
> What happens if you increase statistics for l_orderkey?

statistic target is already at 1000 ...

Stefan

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2006-09-28 16:20:10 Re: [GENERAL] 'pg_ctl -w' times out when unix_socket_directory is
Previous Message Heikki Linnakangas 2006-09-28 16:13:11 Re: Another idea for dealing with cmin/cmax