Re: 2Q: Vacuuming and making queries case insensitive
| От | Sean Davis |
|---|---|
| Тема | Re: 2Q: Vacuuming and making queries case insensitive |
| Дата | |
| Msg-id | 264855a00801271711n7c21cabfx8aac32a4a5575ccd@mail.gmail.com обсуждение исходный текст |
| Ответ на | 2Q: Vacuuming and making queries case insensitive ("sdger erger" <killen.nextdoor@gmail.com>) |
| Ответы |
Re: 2Q: Vacuuming and making queries case insensitive
|
| Список | pgsql-novice |
On Jan 27, 2008 8:07 PM, sdger erger <killen.nextdoor@gmail.com> wrote:
You'll need to tell us what is slow. Use the "explain" command and post the results here. For example:
explain select stuff from table where name ilike 'phil';
where name ilike 'phil'.
Sean
I am using PostgreSQL through the command line. I have written a small application that retrieves me information from a database. I have figured most things I need to know out. But I have two questions I hope you guys can help me with.
Is there any command line script that can make the database run faster? Like vacuuming or something. I'm sorry to ask what is surly a very simple question. But everything is hard to the very inexperienced.
You'll need to tell us what is slow. Use the "explain" command and post the results here. For example:
explain select stuff from table where name ilike 'phil';
I also wonder if it is possible to make command line searches case insensitive? Like when I write WHERE name='PHIL' I want it to be the same as WHERE name='phil'.
where name ilike 'phil'.
Sean
В списке pgsql-novice по дате отправления: