Postgres Pro
Downloads
Home   >   mailing lists

Re: -HEAD planner issue wrt hash_joins on dbt3 ? - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject Re: -HEAD planner issue wrt hash_joins on dbt3 ?
Date
Msg-id 450DA478.9080605@kaltenbrunner.cc
Whole thread Raw
In response to Re: -HEAD planner issue wrt hash_joins on dbt3 ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: -HEAD planner issue wrt hash_joins on dbt3 ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
>> that is the explain for the 4h+ Q9:
>> http://www.kaltenbrunner.cc/files/analyze_q9.txt
> 
> The big problem there seems to be the drastic misestimation of the
> number of rows matching the p_name ~~ '%ghost%' condition.  What does
> pg_stats have for the p_name column?

http://www.kaltenbrunner.cc/files/pg_stat_p_name.txt


Stefan

pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: [pgsql-www] Developer's Wiki
Next
From: Tom Lane
Date:
Subject: Re: -HEAD planner issue wrt hash_joins on dbt3 ?