[PERFORM] Relation of cpu_*_costs?

2004-06-07 Thread SZCS Gbor
Dear Gurus, Please feel free to show me to the archives if my question has already been answered. Last week I fumbled with CPU_TUPLE_COST and revealed that 4 out of 4 tested queries improved by 10-60% if I changed it from 0.01 (default) to 0.40 (ugh). Setting it higher did not bring any

Re: [PERFORM] Relation of cpu_*_costs?

2004-06-07 Thread Tom Lane
=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= [EMAIL PROTECTED] writes: Last week I fumbled with CPU_TUPLE_COST and revealed that 4 out of 4 tested queries improved by 10-60% if I changed it from 0.01 (default) to 0.40 (ugh). Setting it higher did not bring any improvement. That's pretty hard to believe;

Re: [PERFORM] Relation of cpu_*_costs?

2004-06-07 Thread SZCS Gbor
Dear Tom, Thanks for your response. - Original Message - From: Tom Lane [EMAIL PROTECTED] Sent: Monday, June 07, 2004 3:51 PM That's pretty hard to believe; particularly on modern machines, I'd think that moving it down would make more sense than moving it up. You're essentially