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'.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2008-01-28 01:49:26|
|Subject: Re: 2Q: Vacuuming and making queries case insensitive |
|Previous:||From: sdger erger||Date: 2008-01-28 01:07:24|
|Subject: 2Q: Vacuuming and making queries case insensitive|