Mage wrote:
online=# select * from common_logins where username = 'potyty'; online=# select * from common_logins where username like 'potyty';
It's probably worth seeing whether these have different plans (EXPLAIN ANALYSE...) and if the = is using an index but like isn't. If so, try issuing "set enable_indexscan=false" first and see what happens then.
If that makes a difference then I'd guess you have one of two things: 1. A corrupt index (check the REINDEX command) 2. (perhaps more likely) Some localisation issues. What encoding/locale settings are you using? -- Richard Huxton Archonet Ltd
