Skip site navigation (1) Skip section navigation (2)

Re: 2Q: Vacuuming and making queries case insensitive

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 (view raw or flat)
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

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-01-28 01:49:26
Subject: Re: 2Q: Vacuuming and making queries case insensitive
Previous:From: sdger ergerDate: 2008-01-28 01:07:24
Subject: 2Q: Vacuuming and making queries case insensitive

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group