Skip site navigation (1) Skip section navigation (2)

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] (view raw, whole thread or download thread mbox)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group