Can't get Postgres to use indices
От | Othman Laraki |
---|---|
Тема | Can't get Postgres to use indices |
Дата | |
Msg-id | GBEGLFJBEMGPPFJEFJNAEEINCJAA.othman@epitrope.com обсуждение исходный текст |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: