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

From Matteo Beccati
Subject Re: -HEAD planner issue wrt hash_joins on dbt3 ?
Date
Msg-id 4511CDE8.2000400@beccati.com
Whole thread Raw
In response to Re: -HEAD planner issue wrt hash_joins on dbt3 ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

Tom Lane wrote:
> I've committed this change with (for now) 100 as the minimum histogram
> size to use.  Stefan, are you interested in retrying your benchmark?

A first try with ltree gave big improvements on my smaller data set: the 
estimated row count is correct or off by only 1 row. I'm now restoring a 
bigger database to get more reliable results.

I hope Stefan can confirm the improvement on dbt3 too.

Thanks Tom :)


Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com


pgsql-hackers by date:

Previous
From: Gevik Babakhani
Date:
Subject: Re: TODO: Fix CREATE CAST on DOMAINs
Next
From: Bruce Momjian
Date:
Subject: Re: Release notes