Re: [DOCS] Possible mistake in 'Using EXPLAIN' section

2007-10-22 Thread Tom Lane
"James Shaw" <[EMAIL PROTECTED]> 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

Re: [DOCS] Possible mistake in 'Using EXPLAIN' section

2007-10-22 Thread James Shaw
On 10/10/2007, James Shaw <[EMAIL PROTECTED]> wrote: > > On 10/10/2007, Tom Lane <[EMAIL PROTECTED]> wrote: > > "James Shaw" <[EMAIL PROTECTED]> 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 di

Re: [DOCS] Possible mistake in 'Using EXPLAIN' section

2007-10-10 Thread James Shaw
On 10/10/2007, Tom Lane <[EMAIL PROTECTED]> wrote: > "James Shaw" <[EMAIL PROTECTED]> 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". Sho

Re: [DOCS] Possible mistake in 'Using EXPLAIN' section

2007-10-10 Thread Tom Lane
"James Shaw" <[EMAIL PROTECTED]> 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 sto

Re: [DOCS] Possible mistake in 'Using EXPLAIN' section

2007-10-10 Thread Guillaume Lelarge
James Shaw a écrit : > 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? > > I couldn't see this already discus

[DOCS] Possible mistake in 'Using EXPLAIN' section

2007-10-10 Thread James Shaw
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? I couldn't see this already discussed on this list. Is there a URL t