| From: | LARC/J(dot)L(dot)Shipman/jshipman <jeffery(dot)l(dot)shipman(at)nasa(dot)gov> |
|---|---|
| To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | searching using indexes 8.3 |
| Date: | 2008-03-10 17:33:04 |
| Message-ID: | 3D53CC73-3BEA-483E-A396-3EFE7293A29D@nasa.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
When I do a search such as:
EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
QUERY PLAN
------------------------------------------------------------------------
-------------------------------------------
Seq Scan on itemsbyauthor (cost=0.00..971.34 rows=53634 width=34)
(actual time=0.029..25.831 rows=53634 loops=1)
Total runtime: 34.851 ms
(2 rows)
I have an index for the table, but it is not being utilized. Why is
this? How do I get the index to be used?
757-864-7114
LARC/J.L.Shipman/jshipman
Jeffery(dot)L(dot)Shipman(at)nasa(dot)gov
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2008-03-10 17:40:02 | Re: searching using indexes 8.3 |
| Previous Message | Simon Riggs | 2008-03-10 17:14:23 | Re: [PERFORM] multi-threaded pgloader makes it in version 2.3.0 |