Hai all again.
Maybe I've solved the problem, but would like to have some hint on "why".
In the second query I've substituted the last join (natural join tt_rice)
with an additional "where condition". I can do this as I am sure that
the tt_rice table will always contain just one row with one fiel
On 10/25/07, Reg Me Please <[EMAIL PROTECTED]> wrote:
> Il Thursday 25 October 2007 13:20:40 Gregory Stark ha scritto:
> > "Gregory Stark" <[EMAIL PROTECTED]> writes:
> > > "Reg Me Please" <[EMAIL PROTECTED]> writes:
> > >>-> Seq Scan on tt_elem (cost=0.00..29.40 rows=1940
> > >>
Il Thursday 25 October 2007 13:20:40 Gregory Stark ha scritto:
> "Gregory Stark" <[EMAIL PROTECTED]> writes:
> > "Reg Me Please" <[EMAIL PROTECTED]> writes:
> >>-> Seq Scan on tt_elem (cost=0.00..29.40 rows=1940
> >> width=8) (actual time=0.012..0.013 rows=1 loops=1)
> >
> > The d
"Gregory Stark" <[EMAIL PROTECTED]> writes:
> "Reg Me Please" <[EMAIL PROTECTED]> writes:
>
>>-> Seq Scan on tt_elem (cost=0.00..29.40 rows=1940 width=8)
>> (actual time=0.012..0.013 rows=1
>> loops=1)
>
> The discrepancy etween the estim
"Reg Me Please" <[EMAIL PROTECTED]> writes:
>-> Seq Scan on tt_elem (cost=0.00..29.40 rows=1940 width=8)
> (actual time=0.012..0.013 rows=1
> loops=1)
The discrepancy etween the estimated rows and actual rows makes me think
you've not a
