| From: | "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph> |
|---|---|
| To: | "'Christopher Kings-Lynne'" <chriskl(at)familyhealth(dot)com(dot)au>, "'Michael Ryan S(dot) Puncia'" <mpuncia(at)census(dot)gov(dot)ph> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Using LIKE expression problem.. |
| Date: | 2004-05-12 07:46:07 |
| Message-ID: | 200405120733.i4C7XCh9003495@mail.census.gov.ph |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Yes , I already do that but the same result .. LIKE uses seq scan
-----Original Message-----
From: pgsql-performance-owner(at)postgresql(dot)org
[mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Christopher
Kings-Lynne
Sent: Wednesday, May 12, 2004 2:48 PM
To: Michael Ryan S. Puncia
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Using LIKE expression problem..
> In the query plan ..it uses seq scan rather than index scan .. why ? I
> have index on lastname, firtname.
Have you run VACUUM ANALYZE; on the table recently?
Chris
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2004-05-12 07:59:10 | Re: Using LIKE expression problem.. |
| Previous Message | Christopher Kings-Lynne | 2004-05-12 06:48:29 | Re: Using LIKE expression problem.. |