Re: [INTERFACES] Re: Index unused with OR?

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: "Olaf Mittelstaedt" <mstaedt(at)va-sigi(dot)va(dot)fh-ulm(dot)de>, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Re: Index unused with OR?
Date: 1998-05-17 11:04:17
Message-ID: l03110703b18474572af0@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

At 17:59 +0300 on 14/5/98, Olaf Mittelstaedt wrote:

>
> w=> vacuum;
> VACUUM
> w=> explain select * from p where m = 29000;
> NOTICE: QUERY PLAN:
>
> Index Scan on p (cost=0.00 size=0 width=10)

Unrelated to the question in hand - you complained about VACUUM not
properly updating the stats. It seems to me you should use VACUUM ANALYZE
for that to happen. Just vacuuming means elimination of old rows no longer
used.

Herouth

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Herouth Maoz 1998-05-17 11:44:19 Re: [INTERFACES] binary insert with JDBC
Previous Message Byron Nikolaidis 1998-05-15 20:39:51 NEW ODBC DRIVER v.0241