Someday i will ask some question that will makes you think a little
more. You'll see.
I will populate the tables and redo the explain.
Thanks dudes!!
Gerardo
>Gerardo Herzig <gherzig@fmed.uba.ar> writes:
>
>
>>Watch the last row of the explain command. It makes a sequential scan on the pages table, like it is not using the
indexon the "id" field.
>>The result itself is OK, but i will populate the tables so i think that later that sequential scan would be a
problem.
>>
>>
>
>Why do you think that the plans won't change when the tables get bigger?
>
> regards, tom lane
>
>
>
>