Performance Issues

Hi,

I recently setup postgres on a Linux box with 4GB Ram and 2.5 GHz
processor. We have created a database with 1.5 million rows in a
table. When we try to select rows from the table, it is taking enormous
time with the default configuration. It takes 2 to 3 seconds to select
1 row that has been selected with indexed columns.

SELECT * FROM TABLE A WHERE COL1 = 1 AND COL2 = 'ABC'.

We have created index definition as follows

CREATE INDEX IDX ON A(COL1, COL2);

Explain on the above statement shows it is sequential scan. The
process size for the postmaster shows as 4MB (is this normal ?)

Thanks for your help in advance,

Regards,
Ravi

**************************Disclaimer************************************

Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confidential' and intended for use only by the individual
or entity to which it is addressed. You are notified that any use, copying
or dissemination of the information contained in the E-MAIL in any manner
whatsoever is strictly prohibited.

***************************************************************************