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. *************************************************************************** |
