Re: [GENERAL] LIKE conditions in PGSQL very, very slow!

2007-08-13 Thread Alban Hertroys
.ep wrote: > Hi, > > I'm moving from the mysql camp and quite liking things like functions > and such, but a lot of my functionality depends on queries such as > >SELECT id, name, start_date >FROM customer >WHERE name LIKE 'eri%'; > > These kinds of queries are super fast in MySQL be

Re: [GENERAL] LIKE conditions in PGSQL very, very slow!

2007-08-10 Thread Scott Marlowe
On 8/10/07, .ep <[EMAIL PROTECTED]> wrote: > Hi, > > I'm moving from the mysql camp and quite liking things like functions > and such, but a lot of my functionality depends on queries such as > >SELECT id, name, start_date >FROM customer >WHERE name LIKE 'eri%'; > > These kinds of queri

[GENERAL] LIKE conditions in PGSQL very, very slow!

2007-08-10 Thread .ep
Hi, I'm moving from the mysql camp and quite liking things like functions and such, but a lot of my functionality depends on queries such as SELECT id, name, start_date FROM customer WHERE name LIKE 'eri%'; These kinds of queries are super fast in MySQL because "eri%" type conditions al