Subject: Possible mistake in 'Using EXPLAIN' section
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 10/10/2007 8:10:54 AM
"James Shaw" <js102@zepler.net> writes:
> The example given has "Seq Scan on tenk1 (cost=0.00..458.00" in the example,
> but then says, "you will find out that tenk1 has 358 disk pages" and "the
> cost is estimated at 358 page reads". Shouldn't this be 458 disk page
> reads?
No. Why did you stop reading in mid-sentence?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Subject: Possible mistake in 'Using EXPLAIN' section
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 10/22/2007 5:35:20 PM
"James Shaw" <js102@zepler.net> writes:
>> I'm sorry, I misunderstood. I've reread, and understand where the
>> extra 100 comes from now. Perhaps this could be reworded:
>> ...
> Were there any thoughts on this? I was hoping this might be included in the
> manual, since I felt it was somewhat clearer.
Done, sorry for not getting to it sooner.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
|