Kevin Kempter wrote:
> I have a simple query against two very large tables ( > 800million
> rows in theurl_hits_category_jt table and 9.2 million in the
> url_hits_klk1 table )
> I get a very high overall query cost:
> Hash Join (cost=296959.90..126526916.55 rows=441764338 width=8)
Wel
On 8/20/09 4:09 PM, "Kevin Kempter" wrote:
> Hi all;
>
>
> I have a simple query against two very large tables ( > 800million rows in
> theurl_hits_category_jt table and 9.2 million in the url_hits_klk1 table )
>
>
> I have indexes on the join columns and I've run an explain.
> also I've s
Kevin Kempter wrote:
Hi all;
I have a simple query against two very large tables ( > 800million rows
in theurl_hits_category_jt table and 9.2 million in the url_hits_klk1
table )
I have indexes on the join columns and I've run an explain.
also I've set the default statistics to 250 for bot
