Re: [ADMIN] Cost estimates consistently too high - does it matter?

2003-08-14 Thread Tom Lane
Matt Clark [EMAIL PROTECTED] writes: I've noticed that the cost estimates for a lot of my queries are consistently far to high. You seem to be under a misapprehension. The cost estimates are not in units of milliseconds, they are on an arbitrary scale with 1.0 defined as one disk fetch. LIMIT

[ADMIN] Cost estimates consistently too high - does it matter?

2003-08-14 Thread Matt Clark
Hi, I've noticed that the cost estimates for a lot of my queries are consistently far to high. Sometimes it's because the row estimates are wrong, like this: explain analyze select logtime from loginlog where uid='Ymogen::YM_User::3e2c0869c2fdd26d8a74d218d5a6ff585d490560' and result =

Re: [ADMIN] Cost estimates consistently too high - does it matter?

2003-08-09 Thread Matt Clark
PROTECTED] Subject: Re: [ADMIN] Cost estimates consistently too high - does it matter? Matt Clark [EMAIL PROTECTED] writes: I've noticed that the cost estimates for a lot of my queries are consistently far to high. You seem to be under a misapprehension. The cost estimates