Re: [HACKERS] Strange cost computation?

2002-10-30 Thread Stephan Szabo
On Wed, 30 Oct 2002, Stephan Szabo wrote: > On 29 Oct 2002, Ives Landrieu wrote: > > > Hi, > > > > Can anybody explain the following results when using EXPLAIN, > > one time with enable_seqscan=on and one time with enable_seqscan=off. > > What I don't understand is that the nodes created are the s

Re: [HACKERS] Strange cost computation?

2002-10-30 Thread Stephan Szabo
On 29 Oct 2002, Ives Landrieu wrote: > Hi, > > Can anybody explain the following results when using EXPLAIN, > one time with enable_seqscan=on and one time with enable_seqscan=off. > What I don't understand is that the nodes created are the same > (index scan, seq scan), but the costs differ. Ena

[HACKERS] Strange cost computation?

2002-10-30 Thread Ives Landrieu
Hi, Can anybody explain the following results when using EXPLAIN, one time with enable_seqscan=on and one time with enable_seqscan=off. What I don't understand is that the nodes created are the same (index scan, seq scan), but the costs differ. set enable_seqscan=on; explain (SELECT alias96.I