From: Teodorescu Constantin <teo@flex.flex.ro>
To: mstaedt@va-sigi.va.fh-ulm.de
To: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Re: Index unused with OR?
Date: Thu, 14 May 1998 17:28:35 +0300
Message-ID: <199805141428.RAA02682@flex.flex.ro> (raw)
In-Reply-To: <199805141359.PAA04711@gate.va.fh-ulm.de>
> > Not using the index in OR queries was some-time ago a bug in
> > PostgreSQL 6.1 if my memory is good. Think that has been solved in
> > new releases, am I wrong ?
w=> explain select * from p where (m=29000) or (m=30000);
NOTICE: QUERY PLAN:
Seq Scan on p (cost=0.00 size=0 width=10)
It seems that it was not solved :-(
Let's hear also some other answers from the developers ...
Please make another try ! I have discovered once a strange thing : that if I am vacuuming the database as another user than root, the statistics table isn't properly updated. I think that it was a problem with my database, I have reported but noone has reported the same thing again , so ... the problem it has been dropped.
Make another try logging as postgres user, issue "psql yourdb" command and then vacuum. Repeat the EXPLAIN query and check if it's the same result!
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: teo@flex.flex.ro, mstaedt@va-sigi.va.fh-ulm.de
Subject: Re: [INTERFACES] Re: Index unused with OR?
In-Reply-To: <199805141428.RAA02682@flex.flex.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox