| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | "Brian Hirt" <bhirt(at)mobygames(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org>, "Brian A Hirt" <bhirt(at)berkhirt(dot)com> |
| Subject: | Re: question about indexing. |
| Date: | 2001-10-01 01:36:03 |
| Message-ID: | m3eloota4c.fsf@belphigor.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Brian Hirt" <bhirt(at)mobygames(dot)com> writes:
> I have a table with about 1 million rows in it. One of the columns in this
> table is some sort of status (it's an int2). Out of the million rows, only
> about 100 of the rows have a status that is not like the rest.
> Yes, i do vacuum the table.
>
> Does anyone know how to avoid all these table scans?
Cast the value you're testing against in the query to int2 and you may
see an improvement. The planner isn't currently smart enough to
realize it can use the index when the test value in the query is an
int4.
-Doug
--
In a world of steel-eyed death, and men who are fighting to be warm,
Come in, she said, I'll give you shelter from the storm. -Dylan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | R Talbot | 2001-10-01 02:17:38 | Perl connection to Postgres? |
| Previous Message | Stephan Szabo | 2001-10-01 01:23:35 | Re: question about indexing. |