Re: Working with huge amount of data.
| От | hubert depesz lubaczewski |
|---|---|
| Тема | Re: Working with huge amount of data. |
| Дата | |
| Msg-id | 20080211155159.GA22082@depesz.com обсуждение исходный текст |
| Ответ на | Working with huge amount of data. (Mario Lopez <mario@lar3d.com>) |
| Ответы |
Re: Working with huge amount of data.
Re: Working with huge amount of data. RESULTS! |
| Список | pgsql-general |
On Mon, Feb 11, 2008 at 04:37:24PM +0100, Mario Lopez wrote: > SELECT * FROM names WHERE name LIKE ‘keyword%’ > Or > SELECT * FROM names WHERE name LIKE ‘%keyword%’ check this: http://www.depesz.com/index.php/2007/07/30/indexable-field-like-something/ and this: http://www.depesz.com/index.php/2007/09/15/speeding-up-like-xxx/ depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)
В списке pgsql-general по дате отправления: