From: | "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov> |
---|---|
To: | "sdger erger" <killen(dot)nextdoor(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: 2Q: Vacuuming and making queries case insensitive |
Date: | 2008-01-28 01:11:49 |
Message-ID: | 264855a00801271711n7c21cabfx8aac32a4a5575ccd@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Jan 27, 2008 8:07 PM, sdger erger <killen(dot)nextdoor(at)gmail(dot)com> wrote:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-28 01:49:26 | Re: 2Q: Vacuuming and making queries case insensitive |
Previous Message | sdger erger | 2008-01-28 01:07:24 | 2Q: Vacuuming and making queries case insensitive |