Hi, I have been having problems getting Postgres to use indexes in queries.
I read as many postings and FAQs as I could find, but to no avail.
I installed Postgres 7.1 on a Linux machine with ample memory and followed
very standard installation procedures with most default options - the only
difference is that I installed it with the 'enable-locale' and
'enable-multibyte' options turned on. I have many different types of tables,
with indexes, as well as primary keys all over the place. The DB is also
properly vacuumed, so the indexes should be up to date. However, none of the
queries that I run ever use indexes. I even set 'ENABLE_SEQSCAN' to off in
postgresql.conf, but Postgres still uses sequential scans for everything,
even on a join on indexed columns of two tables that have 10,000+ rows.
Any suggestions would be much appreciated!
Thanks,
Othman Laraki
_____________________________
Othman Laraki
Epitrope Corporation
860 Hillview Court, Suite 200
Milpitas, CA 95035, USA
650-814-9580 (phone)
650-745-2449 (fax)
othman@epitrope.com
