Re: [PERFORM] Correcting Hash Join Estimates

2005-04-04 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

[PERFORM] Correcting Hash Join Estimates

2005-04-03 Thread mark . lubratt
Hello! I posted a similar question to this one about a month ago; but, for some reason, it never seemed to be broadcast eventhough it ended up in the archives. So, since I'm still struggling with this, I thought I'd repost... I'm trying to optimize a query and the EXPLAIN ANALYZE (see link

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