Group: pgsql.docs


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