Re: [PERFORM] Correcting Hash Join Estimates

2005-04-03 Thread Mark Lubratt
On Apr 4, 2005, at 12:54 AM, Tom Lane wrote: [EMAIL PROTECTED] writes: I'm trying to optimize a query and the EXPLAIN ANALYZE (see link below) shows that some hash join row estimates are wrong by a factor of 2-3, and upwards of 7-8. I doubt that improving those estimates would lead to markedly bet

Re: [PERFORM] Correcting Hash Join Estimates

2005-04-03 Thread Tom Lane
[EMAIL PROTECTED] writes: > I'm trying to optimize a query and the EXPLAIN ANALYZE (see link below) > shows that some hash join row estimates are wrong by a factor of 2-3, > and upwards of 7-8. I doubt that improving those estimates would lead to markedly better results. You need to think about i