Re: Perfomance Problems - Mailing list pgsql-general

From Brent R. Matzelle
Subject Re: Perfomance Problems
Date
Msg-id 20011106182426.96941.qmail@web13001.mail.yahoo.com
Whole thread Raw
In response to Perfomance Problems  (Manuel Duran Aguete <mdaguete@alsernet.es>)
List pgsql-general
--- Manuel Duran Aguete <mdaguete@alsernet.es> wrote:
> The B app takes less than a second in process each message.
>         The statement is
>         SELECT * FROM table_a
>         WHERE number = 123
>                 AND msg_orig = 'A'
>         ORDER by id;

If number is a VARCHAR then why are you selecting it like it is
an INT ("WHERE number = 123" rather than "WHERE number =
'123'")?  You seem to need an index on number.  The index on
time_b does not look like it is necessary.

Brent



__________________________________________________
Do You Yahoo!?
Find a job, post your resume.
http://careers.yahoo.com

pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: postgres 7.1.1 on Freebsd 4.3?
Next
From: Andrew Gould
Date:
Subject: Re: copy command with PSQL