Postgres Pro
Downloads
Home   >   mailing lists

INDEX PROBLEMS ? - Mailing list pgsql-sql

From PostgreSQL Server
Subject INDEX PROBLEMS ?
Date
Msg-id Pine.LNX.4.44.0211161901570.8254-100000@sunrise2.radiostudiodelta.it
Whole thread Raw
Responses Re: INDEX PROBLEMS ?  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Tree view 
On postgres 7.2.3 I have found what follows:

explain select * from documents where iddoc>1;

Seq Scan on lotti  (cost=0.00..831.79 rows=26783 width=98)

EXPLAIN
explain select * from documents where iddoc=1;

Index Scan using lotti_pkey on lotti  (cost=0.00..2.26 rows=1 width=98)


Why index is not used for operators > and < ????

Alex

pgsql-sql by date:

Previous
From: PostgreSQL Server
Date:
Subject: DATE TIME INDEX ?
Next
From: Tom Lane
Date:
Subject: Re: DATE TIME INDEX ?