From: | "Mitch Vincent" <mitch(at)venux(dot)net> |
---|---|
To: | "Othman Laraki" <othman(at)epitrope(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Can't get Postgres to use indices |
Date: | 2001-05-04 04:00:08 |
Message-ID: | 01f101c0d44e$b5ae98f0$1251000a@windows |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can we see the schema of the tables and the queries that don't use the
indexes along with an EXPLAIN of those queries?
-Mitch
----- Original Message -----
From: "Othman Laraki" <othman(at)epitrope(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, May 04, 2001 12:00 AM
Subject: Can't get Postgres to use indices
>
> 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(at)epitrope(dot)com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Othman Laraki | 2001-05-04 04:09:57 | RE: DB Getting Slower and Slower and Slower.... |
Previous Message | Othman Laraki | 2001-05-04 04:00:05 | Can't get Postgres to use indices |