| From: | Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: index not being used. Why? |
| Date: | 2007-03-09 16:39:35 |
| Message-ID: | 45F18DC7.9050805@fmed.uba.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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(at)fmed(dot)uba(dot)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 index on 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
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-09 16:41:23 | Re: problem upgrading from 8.1.6 to 8.1.8 --- relation <tablename> does not exist |
| Previous Message | Tom Lane | 2007-03-09 16:29:26 | Re: index not being used. Why? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ezequias Rodrigues da Rocha | 2007-03-09 17:22:36 | Statistics |
| Previous Message | Steve Midgley | 2007-03-09 16:38:26 | Re: A form of inheritance with PostgreSQL |